解释这个函数=IF(AX25>0,IF(SUM(ROUND(BH25,1),ROUND(BJ25,1),ROUND(BL25,1))100,"1",""),"")

来源:学生作业学帮网 编辑:学帮网 时间:2024/05/16 20:04:11

解释这个函数
=IF(AX25>0,IF(SUM(ROUND(BH25,1),ROUND(BJ25,1),ROUND(BL25,1))100,"1",""),"")

先判断AX25单元格是否大于0,如果不大于0,则结果为空(两个双引号中什么也不填"").如果大于再判断SUM(ROUND(BH25,1),ROUND(BJ25,1),ROUND(BL25,1))100,如果条件成立,就是SUM(ROUND(BH25,1),ROUND(BJ25,1),ROUND(BL25,1))不等于100,结果则为1,否则还是为空.