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

NickHK

"F. Lawrence Kulchar" wrote in
message ...
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