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

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/02 02:45:59
解释这个函数=IF(AX25>0,IF(SUM(ROUND(BH25,1),ROUND(BJ25,1),ROUND(BL25,1))100,

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

解释这个函数=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,否则还是为空.