:Table logic function IFERROR function Customized error results-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Table logic function IFERROR function Customized error results

Table logic function IFERROR function Customized error results

Author: daogeziyuan • • Table skills • Views 612
  • 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 wrong 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, IFERROR treats it as an empty string value ().

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


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-luo-ji-han-shu-IFERROR-han-shu-zi-ding-yi-bao-cuo-jie-guo.html

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

Related Suggestion