ABOUCHAALA
Canvas Initiate

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

Labels: (1)
Tags (2)
0 Kudos
Reply