DIV/0

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such
as as follows:

A B C D E

1 10 5 0 0 10

2 3.00 =A3 =B3 =C3 =D3

3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+
A2 B2 C2 D2 E2

3 3.50 4.50 DIV/0 DIV/0 5.00


I am keeping, eg, a rolling (running) average.

QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ...

INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message
such as..."NO CALC. POSSIBLE" ??

In other words, can I use the IF function to say...

=If(a3="DIV/0", "No Calc. Possible, a3)

Thanks,

FLKulchar
 
D

Die_Another_Day

You can use "IsError" to get what you want.
=If(IsError(B1/C1),"NO CALC. POSSIBLE",B1/C1)

Charles Chickering
 
F

F. Lawrence Kulchar

THANK YOU

Die_Another_Day said:
You can use "IsError" to get what you want.
=If(IsError(B1/C1),"NO CALC. POSSIBLE",B1/C1)

Charles Chickering
 
J

Joerg

NickHK, this would create a circular reference since the formula needs to go
into cell A3.
Also: IsError catches ANY error, not just Div/0.

Why not simply IF(A1=0,"No Calc Possible",5/A1+A2)?

Cheers

Joerg
 
N

NickHK

I didn't examine the OP's structure/data, just pointed out the existence of
ISERROR.
If the OP wishes to check the Help and/or other references that would be a
good thing.

As you say, there are other (better) ways of achieving the goal.

NickHK
 

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

Top