Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to convert resulting #N/A to 0
Formulas using vlookup or similar returns #N/A if values are not found.
How can this string be converted to 0 other way than manually? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) |