DIV/0

[Guest]

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

 

[Die_Another_Day]

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

Charles Chickering

 

[NickHK]

You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc>)

NickHK

 

[Guest]

THANK YOU

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

Charles Chickering

 

[Guest]

Thank you

You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc>)

NickHK

 

[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

 

[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