| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to get #value! to return a value of 0?
My formula is like this: =A2+B2+C2. However, some of the values in the B2
column are "--," indicating "not applicable". When I use the formula, it interprets this as text, of course, and returns the error value of #VALUE! I want it to treat these as zeroes. How can I do this? I tried doing a FIND AND REPLACE, but it did not recognize any of the "-- " values in the FIND. Can anybody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| How do I check the conditions of 2 fields to return a result | Excel Discussion (Misc queries) | |||
| Return Column header, if row value is > X | Excel Discussion (Misc queries) | |||
| Carriage Return in Excel | Excel Discussion (Misc queries) | |||
| How do I return to the start of the next row - EXCEL 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
