这个公式错在哪里,请高手解答,谢谢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/07/11 03:54:20
这个公式错在哪里,请高手解答,谢谢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-
x){y唙Ox:y뷿\=Yg募b" stpR&Ʀ: @η4ZzF:Z-Qu`55ŢE)>CX$}a}h A:"6v6#>=dW mkjQ@s³);؅, 6eO;f>gnj`cf 4GF 1y"

这个公式错在哪里,请高手解答,谢谢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都是错的.