| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003
How can I replace a #N/A result with "0"?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003
"C" wrote:
How can I replace a #N/A result with "0"? One way, trap the formula's return with ISNA, eg: =IF(ISNA(yourformula),0,yourformula) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
| unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Hybrid Mode
