Nested if Formula


Hello nintex lovers, I need your help for this formula please



Here is what I need to do















If A= "High" or B= "High" or C= "High" or D= "High" ==> "High"
else
If X= "Yes" or V= "Yes" or N= "Yes" or H= "Medium" or P= "Medium" or M= "Medium" or L= "Medium" ==> "Medium"
else
"Low"


And here is the formula I have set up. 



If(or(or(or(A=='High', B=='High'),C=='High'),D=='High'),'High',If(or(or(or(or(or(or(X=='Yes', V=='Yes'),N=='Yes'),H=='Yes'),P=='Yes'),M=='Yes'),L=='Yes'),'Medium','Low')) 



 



High and Low values work perfectly but not Medium, do you see anything wrong please ??? 



 



Thanks


0 replies

Be the first to reply!

Reply