Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It's the darndest thing... .

It *mostly* works... but a couple of the number values in column 'A' don't
seem to correspond correctly.

So that in one case, I have my lovely yellow '36' in column 'A', appearing
in column 'B' as 'Red' (in one case), 'Yellow' (in another case) and 'Green'
(in another case).

It's really bizarre.

'Green' should be like 30<'Green'>35
'Yellow' should be like 36<'Yellow'>45
'Red' should be like 'Red'>46

I'm excited by getting this far but now doubley-stumped as to why it isn't
*quite* working.

But, Bob, you got me farther than I ever got with my torturous ponderings so
I thank you very much for getting me this far :-)

Any idea how I can just. Get. A. Little. Farther?

Much obliged!

"Bob Phillips" wrote:

=IF(A2<30,"",IF(A2<35,"Green",IF(A2<46,"Blue","Red")))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MS Questionnairess" <MSQuestionnairess@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:EB67FD5E-2E8D-4BEA-A7AE-62EDBA57C24C@xxxxxxxxxxxxxxxx
Ex. A2 is a bunch of numbers that have been conditionally formatted to
show
up as green if between 30 and 34, yellow if between 35 and 45 and red if
46
and over.

However, I need B2 to display the word 'green', 'yellow' or 'red'
depending
on the number range in A2.

Intuitively? Easy. In reality? I'm completely stumped :-P

Help?



.