| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to convert resulting #N/A to 0
=IF(ISNA(formula),0,formula)
Jerry "cehipso" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to convert resulting #N/A to 0
"Jerry W. Lewis" wrote: =IF(ISNA(formula),0,formula) Jerry "cehipso" wrote: Thanks a lot to Jerry 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? |
| Reply |
| 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) | |||
Linear Mode
