How do I recognize "#VALUE!" in Excel spreadsheets?
Use IFERROR(value, value_if_error)
This will return TRUE for #VALUE! errors (ERROR.TYPE = 3) and FALSE for anything else.
=IF(ISERROR(A1),ERROR.TYPE(A1)=3)
How do I recognize "#VALUE!" in Excel spreadsheets?
Use IFERROR(value, value_if_error)
This will return TRUE for #VALUE! errors (ERROR.TYPE = 3) and FALSE for anything else.
=IF(ISERROR(A1),ERROR.TYPE(A1)=3)