I have two formula, which I require to merge to have one single formula:
Formula 1
Formula 2Code:=IF(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),Z222&" Shock","")
If either of the formula result is true, it should return value "Shock".Code:=IF(AND(K221>=50,(K222/K221)>=5),Z222&" Shock", "")
I tried different ways to put it in using IF, AND OR but no success......somewhere I'm making logical error, kindly correct/help me.




Reply With Quote
Bookmarks