Formula

[Chris]

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]

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

 

[Gary''s Student]

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