Help with RAG Formula

[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

 

[Trevor Shuttleworth]

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

Regards

Trevor

 

[Bob Phillips]

=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)

 

[Guest]

Trevor,

Worked a treat many thanks

Chris

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

Regards

Trevor

 

[David Biddulph]

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"))