Help with RAG Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,

Can you help with a formuls I am trying to create which turns the cell into
RAG based on the value of abnother cell, the formula is below.

IF Cell T6 is 75% or greater the Cell U6 is Red
IF Cell T6 is between 50% & 75% Cell U6 is Amber
Else Cell U6 is Green

The syntax I'm using is below I cannot get Cell U6 to go Green when the
value in T6 goes below 50%

=IF(T6>0.75,"Red",IF(T6<0.75>0.5,"Amber","Green"))

(I'm using conditional formats to colour the cells as the name)

Thanks guys,

Chris
 
=LOOKUP(A11,{0,0.5,0.75},{"Green","Amber","Red"})

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You don't need the AND(), as the test against 0.75 has already been done.

=IF(T6>=0.75,"Red",IF(T6>=0.5,"Amber","Green"))
 
Back
Top