Hi folks, I am working on this formula that is supposed to do this in column Z
IF cell V=N/A then I need the result of P*R*Y, if V doesn’t contain N/A then, I need the result of P*R*W*Y and finally if P, R, W and Y are blank, I should get nothing.
This is the formula I used, I am not sure why I am getting value “0” instead of blank when cells P, R,W and Y are blank
=IF(V7="N/A",P7*R7*Y7,IF(ISERROR(SEARCH("N/A",V7)),P7*R7*W7*Y7,IF(ISBLANK(P7),"",IF(ISBLANK(R7),"",IF(ISBLANK(W7),"",IF(ISBLANK(Y7),""))))))
As you can see, row 7 is blank so, Z7 should be blank too but it is showing "0".
IF cell V=N/A then I need the result of P*R*Y, if V doesn’t contain N/A then, I need the result of P*R*W*Y and finally if P, R, W and Y are blank, I should get nothing.
This is the formula I used, I am not sure why I am getting value “0” instead of blank when cells P, R,W and Y are blank
=IF(V7="N/A",P7*R7*Y7,IF(ISERROR(SEARCH("N/A",V7)),P7*R7*W7*Y7,IF(ISBLANK(P7),"",IF(ISBLANK(R7),"",IF(ISBLANK(W7),"",IF(ISBLANK(Y7),""))))))
As you can see, row 7 is blank so, Z7 should be blank too but it is showing "0".