[SOLVED] THANK YOU I created the following statement: =IF(AND(K2>0), IF(OR(M2>0, S2>0, Y2>0,Q2>0, W2>0), ((P2+V2+AB2)/(K2 + Q2 + W2),0)) and I'm not getting the results I expect. I wanted to write a formula that, in human speak says: If K2 is greater than 0 and either M2, S2, Y2Q2 or W2 are greater than 0, than perform (P2+V2+AB2)/(K2 + Q2 + W2), else write 0 in the cell. Can someone tell from my formula what I did wrong? Thank you.
Bookmarks