如题所述
计ç®äºï¼æ°å¼ä¸å¯¹ï½ï½
ä½ éè¦çæ¯é¶æ¢¯ç®æ³ï¼å°±è±¡ä¸ªäººæå¾ç¨é£æ ·ï¼å ¬å¼ï¼=IF(A1<20000,0,IF(A1<100000,0.04*(A1-20000),80000*0.04+0.05*(A1-100000)))