=I34*H34 without N/A
 

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

=I34*H34 without 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
--
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

=I34*H34 without N/A
 

Try:

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

Jazz wrote:
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

--
Message posted via http://www.officekb.com

=I34*H34 without N/A
 

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" wrote:

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

=I34*H34 without N/A
 

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)

--
Rick (MVP - Excel)


"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

=I34*H34 without N/A
 

=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.
--
David Biddulph

Jazz wrote:
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

=I34*H34 without N/A
 

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)

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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)

--
Rick (MVP - Excel)


"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

=I34*H34 without N/A
 

Thank you Mike. This is very helpful.

"Mike H" wrote:

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" wrote:

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

=I34*H34 without N/A
 

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

"Bernard Liengme" wrote:

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

.

=I34*H34 without N/A
 

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

"tnazirov via OfficeKB.com" wrote:

Try:

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

Jazz wrote:
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

--
Message posted via http://www.officekb.com

.

=I34*H34 without N/A
 

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

"Rick Rothstein" wrote:

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)

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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)

--
Rick (MVP - Excel)


"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


.

=I34*H34 without N/A
 

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

"David Biddulph" wrote:

=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.
--
David Biddulph

Jazz wrote:
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


.