Welcome Guest
You last visited December 9, 2016, 8:24 am
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 8 replies. Last post 4 years ago by lottogloria.

 Page 1 of 1
cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
 Posted: June 17, 2012, 3:17 pm - IP Logged

LOOKING FOR LMH FORMULA FOR THE 3 AND 4

LOW AS 012
MED AS 3456
HIGH AS 789

LG

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: June 22, 2012, 12:24 pm - IP Logged

What should the formula do?

United States
Member #124493
March 14, 2012
7023 Posts
Offline
 Posted: June 22, 2012, 2:16 pm - IP Logged

LOOKING FOR LMH FORMULA FOR THE 3 AND 4

LOW AS 012
MED AS 3456
HIGH AS 789

LG

i guess you could use a countif functions...so countif(range,0)+countif(range,1)+countif(range,2)...and then if you have sum of 3 then it is low...

cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
 Posted: June 23, 2012, 6:01 am - IP Logged

0,1,2  WOULD GIVE ME THE LETTER  L FOR LOW DIGIT
3,4,5,6  WOULD GIVE ME THE LETTER M FOR MEDIUM DIGIT
7,8,9 WOULD GIVE THE LETTER H FOR HIGH DIGIT

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: June 23, 2012, 6:15 am - IP Logged

HINT:

=IF( when condition , then if true , then if false)

=if( and(condition, condition), then if true, then if false )

... develop

cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
 Posted: June 23, 2012, 2:56 pm - IP Logged

THANKS I WILL TRY THIS

LD

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: June 27, 2012, 6:40 pm - IP Logged

Hi Lottogloria,

Try this.

Assuming that your digit is in cell A1.

=CHOOSE(A1+1, "L", "L", "L","M", "M", "M","M", "H", "H", "H")

Serge.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: June 28, 2012, 8:11 pm - IP Logged

Public Function LMH(digit) As String
LMH = WorksheetFunction.Choose(digit + 1, "LOW", "LOW", "LOW", "MED", "MED", "MED", "MED", "HIGH", "HIGH", "HIGH")
End Function

LOW AS 012
MED AS 3456
HIGH AS 789

cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
 Posted: July 3, 2012, 9:21 pm - IP Logged

WORKS PERFECT THANKS EVERYONE FOR ALL YOUR HELP

LD

 Page 1 of 1