Subtraction that doesn't produce an error

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtract 12 hours from date/time 6
subtract times with a negative result 1
When subtracting dates issue 11
Subtracting Rounded Numbers 6
Subtracting with cells that appear blank 6
Excel Repeating a RAND() function under certain conditions 0
Calculating time in Number Formate 3
Count between dates with some entries marked as "-" 5

Back
Top