ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Á~¸ê©Ò±oµ|¦©Ãº°ÝÃD

Á~¸ê©Ò±oµ|¦©Ãº°ÝÃD

½Ð°Ý¦U¦ì«e½ú

¦p¦ó§Q¥ÎªþÀɤ¤102¦~sheet¤¤ªº¸ê®Æ¹ïÀ³¥XÁ~¸êªí¸ÌªºHÄæÀ³¦©©Ò±oµ|¡AÁÂÁ¡H

Á~¸ê©Ò±o¦©Ãºµ|ÃBªí.zip (35.28 KB)

½Ð»¡²M·¡³W«h
ss

TOP

¦^´_ 2# sunnyso

±z¦n

¦bªþÀÉ 102¦~ sheet¬O¤@­Ó¦©Ãºµ|ÃBªí¡A·íÁ~¸ê¹F¤@©wª÷ÃB®É¡A¤½¥q·|¥ý¦æ´À­û¤u¥N¦©©Ò±oµ|¡A¦¹®É¤S²o¯A¨ì¦³µL§ß¾i¿ËÄÝ¡A¼¾¾iªº¿ËÄݶV¦h¡A¦©Ãºª÷ÃB¶V§C¡C
Á|¨Ò¨Ó»¡AAAªº©³Á~¬O36700¡A¦b102¦~sheet¸Ì¥i¥H¬Ý¨ì¨Ã¥¼¹F¦©Ãº¼Ð·Ç¡A©Ò¥H¦¹­û¤u¤£¦©©Ò±oµ|¡C
¤S¦p­û¤uBBBªº©³Á~¬O84500¡A¥B§ß¾i¤F¨â­Ó¿ËÄÝ¡A¨º»ò¦b102¦~sheet¸Ì´N¬O¹ïÀ³D77Äæ¡AÀ³¦©2020   
©Î¬OCCCªº©³Á~¬O95750¡A¦ý¨S¦³§ß¾i¥ô¦ó¿ËÄÝ¡A¨º»ò¦b102¦~sheet¸Ì´N¬O¹ïÀ³B100Äæ¡AÀ³¦©4910

¥H¤W¡A§Æ±æ´Mªº¸Ñ¨M¤è¦¡¡AÁÂÁ¡C

TOP

H2 ªº¤½¦¡¡Gµ²ªG#N/A (¤£¥i¥Î)
=VLOOKUP($B2, INDIRECT("taxDB"),$K2+2,)

H3 ªº¤½¦¡¡Gµ²ªG¬°0 (¥¿½T¤½¦¡)
=VLOOKUP($B3, INDIRECT("taxDB"),$K3+2,TRUE)

¤£¬O»¡ Vlookup ªº³Ì«á¤@­Ó°Ñ¼Æ¬° Ture ®É, ¥i¥H¬Ù²¤¶Ü?
¬°¦óH2©MH3ªºµ²ªG·|¤£¤@¼Ë?


Á~¸ê©Ò±o¦©Ãºµ|ÃBªí.rar
http://www.mediafire.com/download/91p83vfs94f0u5y/%E8%96%AA%E8%B3%87%E6%89%80%E5%BE%97%E6%89%A3%E7%B9%B3%E7%A8%85%E9%A1%8D%E8%A1%A8.rar

TOP

¦^´_ 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

TOP

¦^´_ 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

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-2-21 23:55 ½s¿è

H2 =IF(B2<47001,0,INDEX('102¦~'!B:M,INT((B2-47001)/500)+3,K2+1))

¦V¤U½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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ÁÂÁÂ

TOP

¸Õ¸Õ¬Ý¡G
¤@¡Bsheet("102¦~")­×§ï¦p¤U¹Ï¡G

¤G¡B
sheet("Á~¸êªí")B2¿é¤J¤½¦¡¦p¤U¡G
=VLOOKUP($B2, '102¦~'!$B$3N$334, $K2+2,TRUE)
´ú¸Õµ²ªG¦p¤U¹Ï¡G

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-2-22 16:29 ½s¿è

¦^´_ 8# aer


    ¤£¬Oµ¥¶Z®É¡A§ï¥Î¬dªí¤è¦¡³B²z
H2 =IF(B2<47001,0,LOOKUP(B2,--LEFT('102¦~'!$A$3:$A$333,FIND("~",'102¦~'!$A$3:$A$333)-1),OFFSET('102¦~'!$B$3:$B$333,,K2)))


­Y¹³9¼Ó´¡¤J¬d¸ß­È¥i¥H´£°ª¬d¸ß³t«×
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD