=IF(AM4-AV4-3500>9000,(AM4-AV4-3500)*0.25-1005,IF(AM4-AV4-3500>4500,(AM4-AV4-3500)*0.2-555,IF(AM4-AV4-3500>1500,(AM4-AV4-3500)*10%-105,IF(AM4-AV4-3500>0,(AM4-AV4-3500)*3%,0))))
AMå代表åºåæ°ï¼ANå代表å项ä¿é©å计ãç¨if设置äºç¬¦åè§åçæ£ç¨æ¡ä»¶ã
å¤å¶å
¬å¼å°wordç¨æ¥æ¾æ¿æ¢æAM ANåä¸ºä½ çç¸åºæ°æ®æå¨åå
æ ¼å³å¯ã
追é®![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95cadc2a03a8ce177f3e660952d4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
æ±è§£
æåªééäº