Originally Posted by
opus
The formula posted by Fizziii should work for most cases, the case in which it gives a wrong(?) result is if both cells are empty. The result of the formula is "Very High", I assume that would not be correct. However this case might never happen.
Code:
=IF(OR(F8="LOW",G8="LOW"),"LOW",IF(OR(F8="MEDIUM",G8="MEDIUM"),"MEDIUM",IF(OR(F8="HIGH",G8="HIGH"),"HIGH",IF(AND(F8="VERY HIGH", G8="VERY HIGH,"VERY HIGH",ELSE))))
This will fix the issue brought up by opus. Thank you opus. (I just added one last if... if both are "VERY HIGH", then it's "VERY HIGH", otherwise it's "ELSE")
Reply With Quote