ExcelBanter - How to detect #N/A and return 0?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to detect #N/A and return 0? (https://www.excelbanter.com/excel-discussion-misc-queries/144501-how-detect-n-return-0-a.html)

Eric

How to detect #N/A and return 0?

Does anyone know how to detect #N/A? if it finds, then return 0 value.
Does anyone have any suggestions/
Thank you in advance
Eric

T. Valko

How to detect #N/A and return 0?

You need to be more specific.

Biff

"Eric" wrote in message
...
Does anyone know how to detect #N/A? if it finds, then return 0 value.
Does anyone have any suggestions/
Thank you in advance
Eric

JE McGimpsey

How to detect #N/A and return 0?

How is #N/A being generated?

If by a lookup, then:

=IF(ISNA(VLOOKUP(...),0,VLOOKUP(...))

In article ,
Eric wrote:

Does anyone know how to detect #N/A? if it finds, then return 0 value.
Does anyone have any suggestions/
Thank you in advance
Eric

All times are GMT +1. The time now is 08:22 PM.