ExcelBanter - Display a "0" when #N/A appears in formula

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

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

- - Display a "0" when #N/A appears in formula (https://www.excelbanter.com/excel-worksheet-functions/80930-display-0-when-n-appears-formula.html)

DarnTootn

Display a "0" when #N/A appears in formula

When working with a formula at returns a #N/A I would like it to display a
"0" instead

Peo Sjoblom

Display a "0" when #N/A appears in formula

=IF(ISNA(formula),0,formula)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"DarnTootn" wrote in message
...
When working with a formula at returns a #N/A I would like it to display a
"0" instead

Duke Carey

Display a "0" when #N/A appears in formula

Try

=IF(ISNA(your formula),0,your formula)

"DarnTootn" wrote:

When working with a formula at returns a #N/A I would like it to display a
"0" instead

DarnTootn

Display a "0" when #N/A appears in formula

Thank you for your help... it works for me... can't believe I had forgotten
that formula... anywho, thanks again

"Peo Sjoblom" wrote:

=IF(ISNA(formula),0,formula)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"DarnTootn" wrote in message
...
When working with a formula at returns a #N/A I would like it to display a
"0" instead

All times are GMT +1. The time now is 11:44 AM.