Help with RAG Formula
 

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

Help with RAG Formula
 

=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

Help with RAG Formula
 

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

"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

Help with RAG Formula
 

Trevor,

Worked a treat many thanks

Chris

"Trevor Shuttleworth" wrote:

=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

Help with RAG Formula
 

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