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