å
¬å¼ï¼=IF(B2<=10,B2*20,IF(B2<=20,200+(B2-10)*30,IF(B2<=30,500+(B2-20)*40,IF(B2<=35,900+(B2-30)*50,1200))))
æè
ï¼=IF(B2<=10,20*B2,IF(B2<=20,30*B2-100,IF(B2<=30,40*B2-300,IF(B2<=35,50*B2-600,1200))))
B2åå
æ ¼è¾å
¥å·¥é¾ï¼C2åå
æ ¼è¾å
¥è®¡ç®
å·¥é¾å·¥èµçå
¬å¼ï¼ä¸æ