Welcome Guest

NetConnect

Internet Domains, simple and cheap

Find a domain name:

Home

The time is now 6:51 pm
You last visited May 23, 2013, 6:51 pm
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 8 replies. Last post 11 months ago by lottogloria.

 Page 1 of 1
cleveland
United States
Member #35444
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

Aruba
Member #123712
February 27, 2012
1799 Posts
Offline
 Posted: June 22, 2012, 12:24 pm - IP Logged

What should the formula do?

Stop breathing!

.

KEEP YOUR EYE ON THE BALL!
NYC
United States
Member #124503
March 14, 2012
5023 Posts
Online
 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...

est modus in rebus --- Catch the Lightning!

He deals the cards to find the answer, the S. G. of chance,

the hidden law of a probable outcome, the numbers lead a dance.       -  Sting.

cleveland
United States
Member #35444
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

Aruba
Member #123712
February 27, 2012
1799 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 #35444
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 #75921
June 2, 2009
308 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.

Aruba
Member #123712
February 27, 2012
1799 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

Stop breathing!

.

cleveland
United States
Member #35444
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