求高手帮忙简化WPS表格函数公式,因IF引用太多无法正常运行,谢谢!_百...答:这样试一下 =IF(A8+B8>38000,IF(A8<8000,(B8-110000+A8)*95%+26000+(8000-A8)*0.8,IF(A8<28000,(B8-30000)*95%+26000,IF(A8<38000,(B8-10000)*95%+9000,B8*95%))),IF(A8+B8>28000,IF(A8>28000,B8*0.9,IF(A8>8000,(20000-A8)*85%+(A8+B8-28000)*0.9,(8000-A8)*0...