这个公式错在哪里,请高手解答,谢谢ROUND(IF(AND((X4-3500),35000,(X4-3500)>9000),(X4-3500)*0.25-1005,IF(AND((X4-3500),9000,(X4-3500)>4000),(X4-3500)*0.2-555,IF(AND((X4-3500),4500,(X4-3500)>1500),(X4-3500)*0.1-105,IF(AND((X4-3500),1500,(X4-

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/08 17:12:06

这个公式错在哪里,请高手解答,谢谢ROUND(IF(AND((X4-3500),35000,(X4-3500)>9000),(X4-3500)*0.25-1005,IF(AND((X4-3500),9000,(X4-3500)>4000),(X4-3500)*0.2-555,IF(AND((X4-3500),4500,(X4-3500)>1500),(X4-3500)*0.1-105,IF(AND((X4-3500),1500,(X4-
这个公式错在哪里,请高手解答,谢谢
ROUND(IF(AND((X4-3500),35000,(X4-3500)>9000),(X4-3500)*0.25-1005,IF(AND((X4-3500),9000,(X4-3500)>4000),(X4-3500)*0.2-555,IF(AND((X4-3500),4500,(X4-3500)>1500),(X4-3500)*0.1-105,IF(AND((X4-3500),1500,(X4-3500)>0),(X4-3500)*0.03,IF((X4-3500)

这个公式错在哪里,请高手解答,谢谢ROUND(IF(AND((X4-3500),35000,(X4-3500)>9000),(X4-3500)*0.25-1005,IF(AND((X4-3500),9000,(X4-3500)>4000),(X4-3500)*0.2-555,IF(AND((X4-3500),4500,(X4-3500)>1500),(X4-3500)*0.1-105,IF(AND((X4-3500),1500,(X4-
公式错了,将公式中的 (X4-3500)>4000) 改为 (X4-3500)>4500),否则从7501到7999都是错的.