devide by 0 error

D

Dreamstar_1961

is there a way to stop the devide by 0 or empty cell error from showing if
the cell you are using is empty?
 
P

Paul B

Dreamstar, one way, something like this, =IF(ISERROR(A1/B1),"",A1/B1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
R

Ron Coderre

Typically by using something like this:

=IF(B1=0,"",A1/B1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
G

Gord Dibben

Just one warning.

This will hide any error that is produced, not just the #DIV/0! error.

I think you would be better off with Ron's suggested formula.


Gord Dibben MS Excel MVP
 
D

Dreamstar_1961

I just found out that this will not work as it has to go back to a office
2003, the problem with Rons is that this is a cubic devision, whick means
that it has to check 3 cells and not just one, and the max formula is being
used, this is the formula I'm using.
=(MAX(INT(B1D/D)*INT(B1W/W)*INT(B1H/H),INT(B1W/D)*(B1H/W)*INT(B1D/H),INT(B1H/D)*INT(B1D/W)*INT(B1W/H))
and this is the formula I'm using with office 2007
=IFERROR(MAX(INT(B2D/D)*INT(B2W/W)*INT(B2H/H),INT(B2W/D)*(B2H/W)*INT(B2D/H),INT(B2H/D)*INT(B2D/W)*INT(B2W/H)),"")
the second hids the error if one of the cell are empty, which I'd prefer,
but as it's going back to 2003 it will not work,
what it's for is a fit test on part verses location.
 
T

Teethless mama

IFERROR function is only work for XL2007, and not work for previous versions.
To make it work for all versions then try this:

=IF(ISERROR(your formula),"",your formula)
 
J

JMB

Perhaps test D,W, or H for 0:
=IF(OR(D=0,W=0,H=0),"",MAX(INT(B1D/D)*INT(B1W/W)*INT(B1H/H),INT(B1W/D)*(B1H/W)*INT(B1D/H),INT(B1H/D)*INT(B1D/W)*INT(B1W/H)))
 
Top