请问公式使用是否正确?为何我得不到正确答案?谢谢!

2个回答

=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)))))