| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtraction that doesn't produce an error
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtraction that doesn't produce an error
Hi
Try this: =IF(ISERROR(A1),0,A1)-IF(ISERROR(B1),0,B1) Regards, Per "Andy" skrev i meddelelsen ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtraction that doesn't produce an error
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to produce Hyperlinks | Excel Discussion (Misc queries) | |||
| Button to produce Popup | Excel Discussion (Misc queries) | |||
| What is the roundoff error in the subtraction function? | Excel Worksheet Functions | |||
| produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
| Error in Addition and Subtraction | Excel Discussion (Misc queries) | |||
Linear Mode
