| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Math Formula Giving Error
I have this formula that subtracts one cell from another and then adds that
to a running total. =(C672-D671)+(C673-D672)+(C674-D673)+(C675-D674)+(C676-D675)+(C677-D676)+(C678-D677)+(D678-C678) My problem is this; on occasion there will be the need to have some cell pairs blank or they'll contain "N/A" in them. When this happens I get a Value error. How can I correct this? Thanks in Advance, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any idea why this is giving me a #Value! Error? | Excel Worksheet Functions | |||
| Giving me a error ( =REF! ) | Excel Worksheet Functions | |||
| Function giving error | Excel Discussion (Misc queries) | |||
| Function giving Error | Excel Worksheet Functions | |||
| UpdateLink giving error 1004 | Excel Programming | |||
Threaded Mode
