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)))



"Dreamstar_1961" wrote:

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.

"Gord Dibben" wrote:

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

On Fri, 4 May 2007 20:09:00 -0700, Dreamstar_1961
wrote:

found the answer, =iferror(a1/b1,"")

"Dreamstar_1961" wrote:

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