Tell me the status based on a percentage

[mickyd67]

Hi all - I think this might be an IF formula, but not 100% sure

I have a calculation that returns a percentage value - based on that percentage (let's say in Cell A1) I want Cell B1 to return a statement based on:

Below 75%: Risk
Between 75.01% & 150%: OK
Greater than or equal to 150.01%: Excess

Not quite sure how to do that.

 

[etaf]

=IF( A1 < =0.75 "Risk", IF( A1 < = 1.5 , "OK", "Excess"))

 

[mickyd67]

=IF( A1 < =0.75 "Risk", IF( A1 < = 1.5 , "OK", "Excess"))

Perfect, thanks a lot!

 

[etaf]

you are welcome