I need a formula that will take a figure from the cell on the left and automatically populate the next cell with "Low Risk", "Moderate Risk", "High Risk" or "Extreme Risk" based on the the below values:
1 - 3 Low Risk
4 - 6 Moderate Risk
8 -12 High Risk
15 - 25 Extreme Risk
For example - if cell A1 is >1 but <3, then "low risk", >4 but <6, then "moderate risk", >8 but <12 then "high risk", >15 but <25 , then "extreme risk".
Try:
Formula:
Please Login or Register to view this content.
But, it has to be said, your risk ranges have gaps ... this doesn't.
If you are ok with the gaps, maybe:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try:
=IF(OR(A1>6,A1<8,A1>25),"No gap",LOOKUP(A1,{1,3.1,8.1,12.1},{"Low","Moderate","High","Extream"}&" risk"))
Quang PT
@bebo: assuming the risk values are integer, you could probably just use =7 or > 25. Otherwise, I think you need to AND the A1>6,A1<8.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks