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

Typically by using something like this:

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

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

XL2002, WinXP


"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?

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

"Dreamstar_1961" wrote in message
...
is there a way to stop the devide by 0 or empty cell error from showing if
the cell you are using is empty?

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?

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?

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?

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)



"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?

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?