Excel Help Please

Reply #8

lottogloria — Wed, 04 Jul 2012 01:21:42 GMT

WORKS PERFECT THANKS EVERYONE FOR ALL YOUR HELP

LD

Reply #7

SergeM — Fri, 29 Jun 2012 00:11:21 GMT

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

Reply #6

frenchie — Wed, 27 Jun 2012 22:40:17 GMT

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.

Reply #5

lottogloria — Sat, 23 Jun 2012 18:56:52 GMT

THANKS I WILL TRY THIS

LD

Reply #4

SergeM — Sat, 23 Jun 2012 10:15:57 GMT

HINT:

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

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

... develop

Reply #3

lottogloria — Sat, 23 Jun 2012 10:01:28 GMT

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

Reply #2

LottoBoner — Fri, 22 Jun 2012 18:16:59 GMT

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

Reply #1

SergeM — Fri, 22 Jun 2012 16:24:19 GMT

What should the formula do

Excel Help Please

lottogloria — Sun, 17 Jun 2012 19:17:53 GMT

LOOKING FOR LMH FORMULA FOR THE 3 AND 4

LOW AS 012

MED AS 3456

HIGH AS 789

THANKS IN ADVANCE

LG