:"Use the IFERROR function to handle error messages in tables"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Use the IFERROR function to handle error messages in tables"

"Use the IFERROR function to handle error messages in tables"

Author: daogeziyuan • • Table skills • Views 628
```html
  • Picture and text skills
  • Case

You can use the IFERROR function to catch and handle errors in formulas.

If the formula evaluates to an error value, IFERROR returns the value you specify; otherwise, it returns the result of the formula.

Grammar

IFERROR(value, value_if_error)

IFERROR function syntax has the following parameters:

￭ Value: required, check whether there are incorrect parameters.

￭ value_if_error: required, the value returned when the formula calculation error occurs.

Counts the following error types: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!.

Description

￭ If value or value_if_error is an empty cell, treat it as an empty string value (IFERROR).

￭ If value is an array formula, IFERROR returns the resulting array for each cell in the range specified in value.

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 翰林文化传媒 Columnist
48 196
single-end

Related Suggestion