## Overview Return the specified value if the value is an error. If it is not an error, return the value. ## Syntax ``` $IFERROR(Value,Value if error) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Value|Formula|Required|Value, formula, or formula to check for error| |Value if error|Formula|Required|Value, formula, or formula to return if the first argument "value" is an error| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Value|Yes|Yes|Yes|Yes|Yes| |Value if error|Yes|Yes|Yes|Yes|Yes| ## Return Value If the value is an error, return the "value if error". Otherwise, return the "value". ### Return Value for Target Column |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and is a drop-down list with values, display the options that match the return value| |Numerical Value (including work volume, progression rate, remaining work volume)|Display return value only if the return value is a half-width numerical value. | |Date (including start and completion)|Display return value only if the return value is in date format. | |Description (including content)|Display return value. | |Check (including lock)|Check ON if the return value is true, check OFF if the return value is false| ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula  ### Parameters  ### Calculation Result  ## Usage Example ② Combination with other functions ### Formula  ### Parameters  ### Calculation Result