Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

formula req'd

0 views

Skip to first unread message

unread,

Jan 24, 2001, 4:31:20 PM1/24/01

On certain calculations that I have done I get the answer

#ref!

which denotes an error.

What formula do I use to say that when I get this message, enter the value
zero?

Regards

unread,

Jan 24, 2001, 4:58:02 PM1/24/01

Look at #REF in Help. It states that that return means you are referring to an
inappropriate or missing cell reference.

unread,

Jan 24, 2001, 5:34:57 PM1/24/01

Eamon,
you should try using the function ISERROR. If you want to have the
formula enter "zero" then try -

=IF((ISERROR(A1),"Zero",A1)

For A1 you might actually have the calculation that is being performed,
just to save you another step.

I hope it works
Martin

0 new messages