- 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
评论列表(196条)
测试