ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/142622-formula.html)

Chris

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

Gary''s Student

Formula

=IF(F5<0.5,"Red",IF(F5<0.75,"Amber","Green"))

--
Gary''s Student - gsnu200721

Gary''s Student

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

All times are GMT +1. The time now is 04:25 PM.