ExcelBanter

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

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

- - #num (https://www.excelbanter.com/excel-discussion-misc-queries/211248-num.html)

Pammy

#num

I have a formula to give a 0 instead of an error. Some of the calculations
give me a #num instead of a 0, . Is there something I could add to the
formula below to either give a 0 or blank but no #num.

IF(ISNA(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y19 2,longv,2,FALSE))

Michael

#num

Use iserror instead of ISNA
IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP( Y192,longv,2,FALSE))
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"Pammy" wrote:

I have a formula to give a 0 instead of an error. Some of the calculations
give me a #num instead of a 0, . Is there something I could add to the
formula below to either give a 0 or blank but no #num.

IF(ISNA(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y19 2,longv,2,FALSE))

porter444

#num

Try this instead:

=IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE),"0",VLOOKU P(Y192,longv,2,FALSE)

Per Jessen

#num

Hi

Try to substitute "ISNA" with "ISERROR"

Regards,
Per

"Pammy" skrev i meddelelsen
...
I have a formula to give a 0 instead of an error. Some of the calculations
give me a #num instead of a 0, . Is there something I could add to the
formula below to either give a 0 or blank but no #num.

IF(ISNA(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y19 2,longv,2,FALSE))

All times are GMT +1. The time now is 02:07 PM.