Prev: Future date with six day week including holidays
Next: vlookup 3 sheets
From: painter50 on 7 Mar 2010 21:13
I get this #DIV/O! when I divide two cell that both total 0.

These cell will not always be used in the spreadsheet. Is there any way to
show the total of these cell to be 0 when not used?
--
Joe
From: Bernard Liengme on 7 Mar 2010 21:25
=IF(A2=0,0,A1/A2)
or in Excel 2007
=IFERROR(A1/A2,0)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"painter50" <painter50(a)discussions.microsoft.com> wrote in message
news:256D8868-F028-462D-8458-5DEB6690A29C(a)microsoft.com...
> I get this #DIV/O! when I divide two cell that both total 0.
>
> These cell will not always be used in the spreadsheet. Is there any way
> to
> show the total of these cell to be 0 when not used?
> --
> Joe

From: T. Valko on 7 Mar 2010 21:25
Maybe something like this...

If you have something like this: =A1/B1, and B1 is an empty cell then try it
like this:

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

--
Biff
Microsoft Excel MVP


"painter50" <painter50(a)discussions.microsoft.com> wrote in message
news:256D8868-F028-462D-8458-5DEB6690A29C(a)microsoft.com...
>I get this #DIV/O! when I divide two cell that both total 0.
>
> These cell will not always be used in the spreadsheet. Is there any way
> to
> show the total of these cell to be 0 when not used?
> --
> Joe


From: Stan Brown on 7 Mar 2010 21:28
Sun, 7 Mar 2010 18:13:01 -0800 from painter50 <painter50
@discussions.microsoft.com>:
>
> I get this #DIV/O! when I divide two cell that both total 0.
>
> These cell will not always be used in the spreadsheet. Is there any way to
> show the total of these cell to be 0 when not used?

=if(A2,A1/A2,0)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
From: painter50 on 7 Mar 2010 22:37
This is the formulas I trying to fix

=(I5-P5)/Q5
I5=0 P5=0 Q5=0

I used =IF(ISERROR(I5-P5),"-",I5-P5) and it worked fine. The problem is
when I try to divide the (I5-P5)
Joe


"painter50" wrote:

> I get this #DIV/O! when I divide two cell that both total 0.
>
> These cell will not always be used in the spreadsheet. Is there any way to
> show the total of these cell to be 0 when not used?
> --
> Joe
 |  Next  |  Last
Pages: 1 2
Prev: Future date with six day week including holidays
Next: vlookup 3 sheets