=I34*H34 without N/A

[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

 

[Bernard Liengme]

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

 

[tnazirov via OfficeKB.com]

Try:

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

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

 

[Mike H]

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

 

[Rick Rothstein]

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)

 

[David Biddulph]

=I34*H34 will not display N/A unless I34 or H34 or both contains N/A.

If you were getting *zero* from =I34*H34 with H34 or I34 empty, then you
could change it to either
=IF(COUNT(H34:I34)=2,I34*H34,"") or
=IF(OR(H34="",I34=""),"",I34*H34)
but you're telling us you're getting N/A, so you need to tackle why you're
getting that.

 

[Rick Rothstein]

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)

 

[Jazz]

I appreciate the insights Bernard. Thank you for the help.

 

[Jazz]

Thank you Mike. This is very helpful.

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

 

[Jazz]

Very nice! Thank you Sir. I am thankful for the help.

 

[Jazz]

This is great stuff! Thank you Rick. I appreciate you sharing your
knowledge with me.

 

[Jazz]

Hi David. Thank you for your instruction. I am thankful that you helped me.
Thank you.