How to Replace #N/A with 0 in Excel or blank - Simple Formula?

PHOTO EMBED

Sat Aug 03 2024 14:13:25 GMT+0000 (Coordinated Universal Time)

Saved by @Swietoslawa 

'// Replacing #N/A with 0 in Excel using Formula.
'   =IFERROR (expression, value-if-error)

=IFERROR(VLOOKUP(2,2,1,FALSE),"0") 
' - Display value if no error 
' - Display 0 if error

'//Replace #N/A with blank
=IFERROR(VLOOKUP(2,2,1,FALSE),"")
content_copyCOPY

https://officetricks.com/replace-na-excel-with-0-or-blank-formula/