Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
"MS Questionnairess" skrev i
en meddelelse ...
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?
Here's one more way to do it.
In B2:
=INDEX({"No color","Green","Yellow","Red"},SUM((A2={46,35,30, 0})+0))
--
Best regards
Leo Heuser
Followup to newsgroup only please.
|