When cells I34 and/or H34 are blank, your formula should display 0
When either cell holds text, your formula should display #VALUE!
I am not sure how you are getting #N/A unless one of the cells is already
displaying #N/A

Try one of these
=IF(ISERROR(I34*H34 ),"",I34*H34)
=IFERROR(I34*H34,"") in Excel 2007+ only

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme




"Jazz" wrote in message
...
I have a worksheet with this formula =I34*H34 in J34. When cells I34 and
H34
have no numbers in them J34 displays #N/A. Can you tell me how to change
my
current formula =I34*H34, so that if I34 and H34 are empty J34 will remain
blank instead of displaying #N/A