How can I get excel to ignore formula in dependant cells...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted - 21 Nov 2005 20:28 GMT

Hi, I need to run a formula on cells which themselves contain formula. The
second formula is subtracting, say, A1 from B1. The problem is when there are
no answers in the dependant cells (A1, B1 or both) – it, as expected just
gives a value of #VALUE!

How can I get excel to ignore the formula and return the value of zero, when
no data/numbers have been generated by the original/initial formula/dependant
cells??

Thanks in advance.

Ted.

Reply to this Message

SteveG - 21 Nov 2005 20:38 GMT

Ted,

=IF(ISERROR(sum(B1-A1)),0,SUM(B1-A1))

Cheers,

Steve

Signature

SteveG

Reply to this Message

Ron Rosenfeld - 21 Nov 2005 20:49 GMT

>Hi, I need to run a formula on cells which themselves contain formula. The
>second formula is subtracting, say, A1 from B1. The problem is when there are
[quoted text clipped - 8 lines]
>
>Ted.

One thing you can do is to keep your problem in the same thread, so that people
won't be wasting time posing solutions that you have tried but have already
failed, for one reason or another.

--ron

Reply to this Message

Ted - 21 Nov 2005 21:09 GMT

sorry, I thought that once more messages had been added, older ones get moved
to other pages, so are less likely to be seen - I tried to re-post one a
couple of days ago using the " click this link to continue receiving
notifications for this thread." thread, but received nothing from it (hence
me assuming that once messages are pushed to page two onward they are not
seen).

Sorry about that - I'll make sure I keep to the original thread, to which
you recently replied:

URL
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.excel.worksheet.functions&mid=cbdf7b8c-0b58-4c00-95c0-f2fbd7a0c4c5

Thanks, and sorry about that.

Ted.

> >Hi, I need to run a formula on cells which themselves contain formula. The
> >second formula is subtracting, say, A1 from B1. The problem is when there are
[quoted text clipped - 14 lines]
>
> --ron

Reply to this Message

Roger Govier - 21 Nov 2005 22:03 GMT

Hi Ted

See answer posted to your earlier thread.

Regards

Roger Govier

> Hi, I need to run a formula on cells which themselves contain formula. The
> second formula is subtracting, say, A1 from B1. The problem is when there are
[quoted text clipped - 8 lines]
>
> Ted.

Reply to this Message