Returns the value True or False depending if the value is an error (not #N/A).
|value||The value that you want to test.|
|* This function is only available for backwards compatibility and should never be used.|
* The ISERROR function should be used instead because it is exactly the same and includes identifiying #N/A
* The IFERROR function should be used when you want an If-Then-Else condition.
* The "value" can refer to a value, text string, cell reference, formula or a named range.
* This function will not identify cells that contain a #N/A as an error.
* You can use the ISBLANK function to return True or False depending if the value is blank.
* You can use the ISNA function to return True or False depending if the value is #N/A.
* You can use the ISREF function to return the value True or False depending if the value is a cell reference.
* You can use the ERROR.TYPE function to return the number corresponding to a particular error value in a cell.
* For the Microsoft documentation refer to support.microsoft.com
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top