devide by 0 error
 

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

devide by 0 error
 

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?

devide by 0 error
 

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?

devide by 0 error
 

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?

devide by 0 error
 

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?

devide by 0 error
 

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?

devide by 0 error
 

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?

devide by 0 error
 

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?