Your second formula will give a blank, as those ISNA() functions will always
return FALSE.
Your third formula is invalid syntax.
Your first formula should not work, as the parentheses don't match.
What are you trying to achieve? If you want a blank if none of your 4
conditions are met, you could use
=IF((I4="R");H4;IF((H40);H4*E4;IF((I4=0);J4*E4;IF ((J4H4);J4*E4;""))))
or if you want a zero in that case, you can replace the "" with 0.
--
David Biddulph

"IF(ISNA ERROR" <IF(ISNA wrote in message
...
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;" ")