Risk Score Formula

Karl86

Hi Im looking for some help please.

In for my Project Raid Log I would like a formula based on risk score to show the following symbols

Risk score of 25 - 20 - Black

Risk score of 19 -14 - Red

Risk Score 13 - 08 - Amber/Yellow

Risk Score of 0 -7 - Green

Thanks in advanced.

Nick Korna

Hi @Karl86,

A nested IF should take care of this for you:

=IF([Risk score]@row >= 20, "Gray", IF([Risk score]@row >= 14, "Red", IF([Risk score]@row >= 8, "Yellow", "Green")))

Sample output:

I've used "Gray" here as I can't see a symbol set with black, but if needs be just substitute the relevant value in place in the formula.

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

Karl86

Hi Nick,

This is perfect thank you for this. Sorry forgot to add if we can have formula if risk score is blank can we show as N/A please?

Many thanks

Karl86

Thanks @Nick Korna

This is perfect thank you for this. Sorry forgot to add if we can have formula if risk score is blank can we show as N/A please?

Nick Korna

Hi @Karl86,

Amended slightly to give N/A if score is blank (but another cell in the row is filled in):

=IF([Risk score]@row >= 20, "Gray", IF([Risk score]@row >= 14, "Red", IF([Risk score]@row >= 8, "Yellow", IF([Risk score]@row <> "", "Green", "N/A"))))

If nothing else in the row has anything in, then this will be blank.