#DIV/O!

P

painter50

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

T. Valko

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

Stan Brown

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

painter50

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top