IF函数中有"",""是什么意思=IF(F3="","",IF(F366,"×","○")))=IF(E3="","",ABS(E3-E11))这两个函数是什么意思?

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/29 08:14:56
IF函数中有

IF函数中有"",""是什么意思=IF(F3="","",IF(F366,"×","○")))=IF(E3="","",ABS(E3-E11))这两个函数是什么意思?
IF函数中有"",""是什么意思
=IF(F3="","",IF(F366,"×","○")))
=IF(E3="","",ABS(E3-E11))这两个函数是什么意思?

IF函数中有"",""是什么意思=IF(F3="","",IF(F366,"×","○")))=IF(E3="","",ABS(E3-E11))这两个函数是什么意思?
""表示单元格为空.
不是"","",这是两个参数.
=IF(E3="","",ABS(E3-E11)):
如果E3为空,公式返回空,否则运算ABS(E3-E11),也就是求E3-E11的绝对值.
=IF(F3="","",IF(F366,"×","○")))
如果F3为空,返回空;
否则(如果F3不为空),进行第二层IF运算:
第二层IF:如果F3小于61,得到x,否则继续进行第三层IF
第三层IF:如果F3大于66,得到X.如果66>=F3>=61,那就得到O.