Subtraction that doesn't produce an error

Andy · External Since: Mar 23, 2006 Posts: 253

I want to do simple subtraction eg =A1-B1
The problem is, a1 might have an error in it and b1 might have an error in
it.
If either A1 or B1 has an error, I'd want it to just return whatever number
it has.
That is, if A1 is 7 and B1 has an error, then I'd like it to return 7
(substituting 0 for the error).
Any ideas? Thanks.

Luke M · External Since: Jan 08, 2009 Posts: 187

=IF(ISERROR(A1),0,A1)-IF(ISERROR(B1),0,B1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Andy" wrote:

> I want to do simple subtraction eg =A1-B1
> The problem is, a1 might have an error in it and b1 might have an error in
> it.
> If either A1 or B1 has an error, I'd want it to just return whatever number
> it has.
> That is, if A1 is 7 and B1 has an error, then I'd like it to return 7
> (substituting 0 for the error).
> Any ideas? Thanks.

Per Jessen · External Since: Jan 27, 2009 Posts: 32

Hi

Try this:

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

Regards,
Per

"Andy" <Andy.DeleteThis@discussions.microsoft.com> skrev i meddelelsen
news:E6AB6567-8A05-4AEA-977E-AA1F5A305091@microsoft.com...
>I want to do simple subtraction eg =A1-B1
> The problem is, a1 might have an error in it and b1 might have an error in
> it.
> If either A1 or B1 has an error, I'd want it to just return whatever
> number
> it has.
> That is, if A1 is 7 and B1 has an error, then I'd like it to return 7
> (substituting 0 for the error).
> Any ideas? Thanks.