=I34*H34 without N/A

  • Thread starter Thread starter Jazz
  • Start date Start date
J

Jazz

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
 
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
 
Hi,

Getting an NA error as a result of multiplication is a bit odd are you sure
it's not a VALUE error? This should suppress an error

=IF(ISERROR(I34*H34),"",H34*I34)

Mike
 
I get 0 displayed when both those cells are empty. However, you probably
don't want that displayed either. Try this formula...

=IF(OR(I34=0,H34=0),"",I34*H34)

which leave J34 blank if **either** I34 or H34 (or both) are blank. If only
want J34 to be blank **only** when both I34 and H34 are blank (and display 0
if only one is blank) then use this instead...

=IF(AND(I34=0,H34=0),"",I34*H34)
 
Whoops! Those 0's were supposed to have been "" (empty strings). Here are
the two formulas as they were supposed to have been posted (use whichever
you need as per my original description for the OR or AND function calls)...

=IF(OR(I34="",H34=""),"",I34*H34)

=IF(AND(I34="",H34=""),"",I34*H34)
 
Thank you Mike. This is very helpful.

Mike H said:
Hi,

Getting an NA error as a result of multiplication is a bit odd are you sure
it's not a VALUE error? This should suppress an error

=IF(ISERROR(I34*H34),"",H34*I34)

Mike
Click to expand...
 
Back
Top