Using If formula for Rag Status Red Amber and Green

[mrmischief]

Dear All

I need to create a formula where by example using if formula

85% green
81%-84% Amber
<80% Red

Like =if Cell X 85=>G Or/AND 81%- 84% A OR/AND <81 Red

Any ideas?

I would use the conditional formatting to do this but my manager would like it as a formula cell.

Thank you All

 

[Asala42]

A nested if should be fine.

=IF(A2>=.85,"Green",IF(A2>=.8,"Amber","Red"))

 

[mrmischief]

Hi Asala42

Thank you however when I place 80% It remains on Amber.