Excel Help Please

LOOKING FOR LMH FORMULA FOR THE 3 AND 4

LOW AS 012
MED AS 3456
HIGH AS 789

THANKS IN ADVANCE
           LG

What should the formula do?

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...

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

THANKS IN ADVANCE

HINT:

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

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

          ... develop

THANKS I WILL TRY THIS

LD

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.

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

WORKS PERFECT THANKS EVERYONE FOR ALL YOUR HELP

LD