:Tabular Logic Function IFNA Function Change Error Value #N/A-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Tabular Logic Function IFNA Function Change Error Value #N/A

Tabular Logic Function IFNA Function Change Error Value #N/A

Author: daogeziyuan • • Table skills • Views 1038
  • Picture and text skills
  • Case

If the formula returns the error value #N/A, the result returns the value you specify; otherwise, the result of the formula is returned.

Grammar

IFNA(value, value_if_na)

Value: Parameter used to check for error value #N/A.
Value_if_na: The value to be returned when the formula calculation result is the error value #N/A.


Description

If Value or Value_if_na is an empty cell, IFNA treats it as an empty string value ().
If Value is an array formula, IFNA returns the results as an 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-IFNA-han-shu-gai-bian-cuo-wu-zhi-N-A.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu Tomi_Once Columnist
48 196
single-end

Related Suggestion