Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
- From: JE McGimpsey <jemcgimpsey@xxxxxxxx>
- Date: Mon, 22 Jan 2007 10:59:14 -0700
One way:
=IF(A2<30,"",IF(A2<35,"green",IF(A2<=45,"yellow","red")))
In article <EB67FD5E-2E8D-4BEA-A7AE-62EDBA57C24C@xxxxxxxxxxxxx>,
MS Questionnairess <MSQuestionnairess@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
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?
- Prev by Date: Re: Formula won't adjust after sorting data
- Next by Date: Re: Formula won't adjust after sorting data
- Previous by thread: Formula or Macro to insert Data in Cell when having more than 7 Functions
- Next by thread: Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
- Index(es):
