ExcelBanter - Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/172201-excel-2003-a.html)

Excel 2003

How can I replace a #N/A result with "0"?

Max

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
---

All times are GMT +1. The time now is 07:01 AM.