=IF((I4="R");H4;IF((H40);H4*E4;IF((I4=0);J4*E4;IF ((J4H4);J4*E4)
Is there anyway to write formula to get 0, or leave it empty when the #N/A
is a result in the other formula?Here is my Example:
1.Formula is working fine
=IF((I4="R");H4;IF((H40);H4*E4;IF((I4=0);J4*E4;IF ((J4H4);J4*E4)
2.This formula is not working
=IF(ISNA(I17="R");H17;"")&IF(ISNA(H4=0);G4+I4*E4; "")&IF(ISNA(I4=0);J4*E4;"")&IF(ISNA(J4H4);J4*E4;" ")
3. #VALUE!
=IF(ISNA(I17="R");H17;"");IF(ISNA(H4=0);G4+I4*E4; "");IF(ISNA(I4=0);J4*E4;"");IF(ISNA(J4H4);J4*E4;" ")
|