| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
