aer

¦^´_ 3# shootingstar

½Ð°Ý¤@¤U¡A©Ò±oµ|¬O§_¬°¨ú¸û§Cªº¯Å¶Z¡H§Y±z©ÒÁ|¨Ò¤l¡A©Ò±o95750¬O¤¶©ó95500 ~ 96000¤§¶¡¡A¥BµL§ß¾i¤H¡A¨äµ|ÃB¬O§_¨ú¥Î95500ªº¯Å¶Z¡H©Î¬O¨ú¸û°ªªº96000¯Å¶Z©O¡H

aer

¦^´_ 1# shootingstar

HÄæ©Ò±oµ|¤½¦¡
H2=IF(AND($B2>47000,$B2<=110000),INDEX('102¦~'!A:M,ROUNDUP($B2/500,0)-92,MATCH($K2,'102¦~'!$2:$2)),IF(AND($B2>110000,$B2<=120000),INDEX('102¦~'!A:M,ROUNDUP(($B2-111000)/1000,0)+129,MATCH($K2,'102¦~'!$2:$2)),IF(AND($B2>120000,$B2<=150000),INDEX('102¦~'!A:M,ROUNDUP(($B2-120000)/1500,0)+138,MATCH($K2,'102¦~'!$2:$2)),IF($B2>150000,INDEX('102¦~'!A:M,ROUNDUP(($B2-150000)/2000,0)+158,MATCH($K2,'102¦~'!$2:$2)),0))))
¦V¤U½Æ»s

aer

¦^´_ 7# ML089

ª©¥Dªº¤½¦¡¥u¾A¥Î©³Á~¤p©ó111000¥H¤U¡A¶W¹L111000«h·|¨ú¿ù­È¡C­ì¦]¬OÁ~¸ê©Ò±o¯Å¶Z¨Ã«D³£¬O¶¡¹j500¬°¤@¯Å¡A½ÐÀ°¦£¬Ý¤@¤U¤½¦¡­n¦p¦ó­×¥¿¡HÁÂÁÂ

aer

¦^´_ 11# ML089

ÁÂÁª©¥DªºÂ²¤Æ¤½¦¡¡A¤£¹L¤½¦¡¤¤ªº10¡A¬O§_À³¬°11©O¡H
H2 =IF(B2<47001,0,INDEX('102¦~'!B:M,ROUNDUP(LOOKUP(B2,{4.7,11,12,15}*10^4+1,{3,129,139,159}-1+(B2-{4.7,11,12,15}*10^4)/{500,1000,1500,2000}),0),K2+1))