Project Status based on threshold

HI All,

I have a table of status thresholds which are:

On Track - <5%
At Risk - 5-9%
Critical Risk - >10%

I would like to check in the delta column (values in percent) on my spreadsheet and based on these thresholds return the relevant status (on track, at risk, critical risk) automatically in a status column.

I can't see how an IF formula would help as it's only allowing a TRUE or FALSE result, is there a better way to do this?

Many Thanks
Burridge13

Try this
=IF(value<5%,"On Track",IF(value<=10%,"At Risk","Critical Risk"))

Thank you, this is the closest I have got however it's only returning Critical Risk and On Track.

All of them! :o)

However, yours is the one I am currently using.

I've updated to this:

=IF(K7<0.05,"On Track",IF(AND(K7>=0.05,K7<=0.09),"At Risk","Critical Risk"))

K is the Delta column.

Originally Posted by alansidman

Assume the Delta in column B and Status in column D.

In D, type =if(B1<.05,"On Track",if(and(B1>=.05,B1<=.09),"At Risk","Critical Risk")) and copy down.

You do not need the AND
=if(B1<.05,"On Track",if(B1<=.09,"At Risk","Critical Risk"))

Perfect, that is working like a dream....thank you all for your help.