ExcelBanter - Remove errors

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

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

- - Remove errors (https://www.excelbanter.com/excel-worksheet-functions/146529-remove-errors.html)

Steve[_4_]

Remove errors

I am using a vlookup finction, and when it doesn't find a record it
returns an N/A error. Is there any way to remove the N/A error in the
formula so I can sum the returned data? Thanks.

Teethless mama

Remove errors

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

"Steve" wrote:

I am using a vlookup finction, and when it doesn't find a record it
returns an N/A error. Is there any way to remove the N/A error in the
formula so I can sum the returned data? Thanks.

Duke Carey

Remove errors

New in Excel 2007 is the IfError() function, used like so.

=IFERROR(your formula,0)

"Steve" wrote:

I am using a vlookup finction, and when it doesn't find a record it
returns an N/A error. Is there any way to remove the N/A error in the
formula so I can sum the returned data? Thanks.

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