Thread: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
One way:

=IF(A2<30,"",IF(A2<35,"green",IF(A2<=45,"yellow"," red")))

In article ,
MS Questionnairess
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?
Reply With QuoteReply With Quote