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

"Trevor Shuttleworth" wrote in message
...
=IF(T6=0.75,"Red",IF(AND(T6=0.5,T6<0.75),"Amber" ,"Green"))

Regards

Trevor

"Chris" wrote in message
...
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(T60.75,"Red",IF(T6<0.750.5,"Amber","Green"))

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

Thanks guys,

Chris