| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Hi Guys,
Can anyone help with the following formula, I can write may argument but cannot get the formula to work? if cell F5 is 50% or less then Cell G5 = Red if cell F5 is greater the 50% & less then 75% then Cell G5 = Amber If cell F5 is greater the 75% Cell G5 = Green Thanks in advance, Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
=IF(F5<0.5,"Red",IF(F5<0.75,"Amber","Green"))
-- Gary''s Student - gsnu200721 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
=IF(F5<0.5,"Red",IF(F5<0.75,"Amber","Green"))
-- Gary''s Student - gsnu200721 "Chris" wrote: Hi Guys, Can anyone help with the following formula, I can write may argument but cannot get the formula to work? if cell F5 is 50% or less then Cell G5 = Red if cell F5 is greater the 50% & less then 75% then Cell G5 = Amber If cell F5 is greater the 75% Cell G5 = Green Thanks in advance, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
