ä½ çé¦åæ¥æ¾å½æ°å ¬å¼ï¼æåé¢æ¼äºä¸ä¸ªé»è¾å¼â1âââ模ç³å¹é ã
éé¢æ¹ä¸ºï¼
=IF(D5>3500,(D5-3500)*VLOOKUP((D5-3500),B$19:E$25,4,1)-VLOOKUP((D5-3500),B$19:F$25,5,1),)
ï¼æåªç»ä½ æ£æ¥VLOOKUP()ï¼åå¼çå
¶ä»è®¾è®¡ä½ èªå·±çå¦ï¼