è¥ä»Aåä»A2å¼å§æ¯ä¸ç»©ï¼å¨B2è¾å
¥å
¬å¼ï¼
=LOOKUP(A2-1%%,{0,9999,30000,50000,80000,100000,120000,150000,180000,210000,230000},{0,0.04,0.06,0.08,0.1,0.12,0.14,0.16,0.18,0.2,0.22})
å¤å¶å¹¶ä¸æï¼B2å¼å§çBåå°±æ¯å¯¹åºçæææ¯çï¼
å¨C2åå
æ ¼è¾å
¥å
¬å¼ï¼
=A2*LOOKUP(A2-1%%,{0,9999,30000,50000,80000,100000,120000,150000,180000,210000,230000},{0,0.04,0.06,0.08,0.1,0.12,0.14,0.16,0.18,0.2,0.22})
å¤å¶å¹¶ä¸æï¼æå¾å°±æ¯A2å¼å§æ¯ä¸ä¸ªä¸ç»©æ ¸ç®åºæ¥çææ绩æéé¢äºã
温馨提示:答案为网友推荐,仅供参考