| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
result returns #N/B
When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is it
possible to change the result in 0 (zero)? It would help me to use it in calculations. E.g. when i use SUM and one of the results is #N/B, the result of the SUM is #N/B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
