请问公式使用是否正确?为何我得不到正确答案?谢谢!=IF(AM4>7,AL4*0.95,IF(AM4>10,AL4*0.5,IF(AM4>20,AL4*0,IF(AM4>40,AL4*(-0.1),IF(AM4>60,AL4*(-0.3),AL4)))))用法是否正确?在线等答案，请各位大虾帮忙，谢谢！
2019-05-28
请问公式使用是否正确?为何我得不到正确答案?谢谢!
=IF(AM4>7,AL4*0.95,IF(AM4>10,AL4*0.5,IF(AM4>20,AL4*0,IF(AM4>40,AL4*(-0.1),IF(AM4>60,AL4*(-0.3),AL4)))))用法是否正确?
在线等答案，请各位大虾帮忙，谢谢！
优质解答
=IF(AM4>60,AL4*-0.3,IF(AM4>40,AL4*-0.1,IF(AM4>20,AL4*0,IF(AM4>10,AL4*0.5,IF(AM4>7,AL4*0.95,AL4)))))
=IF(AM4>60,AL4*-0.3,IF(AM4>40,AL4*-0.1,IF(AM4>20,AL4*0,IF(AM4>10,AL4*0.5,IF(AM4>7,AL4*0.95,AL4)))))