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

¯Å¶Zªº¿ï¾Ü

¯Å¶Zªº¿ï¾Ü

¦U¦ì«e½ú¡G
§Úªº°ÝÃD¬O¡A§Ú¦³¤@­Ó¸ê®Æ¯Å¶Z1000¦Ü10500¡A1000¥H¤U(§t)ªº¿é¤J­È¨äµ²ªG³£¥X²{1000¡A¦ý¥u­n¦b¦U¶µ¯Å¶Z¤º(§t-¦p¿é¤J­È1001~1500¡A¨äµ²ªG´N¥X²{1500¡A¥H¤UÃþ±À)¡A¨ä©Ò­nªºµ²ªG¦p¤u§@©³½Z-µ²ªG¡C
½Ð°Ý¨ä¨ç¼Æ­n¦p¦ó³]©w¡C

°ÝÃD17.rar (6.9 KB)

§Æ±æ¤ä«ù!

¦^´_ 1# s7659109


    B2=LOOKUP(A2,ROW($A$1:$A$20)*500)+500
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¥D¡G
ÁÂÁ¡A¦ý¦pªG¶µ¦¸A11¶}©l¡A«á­±¦¨¤£³W«h®É¡A«h¨ç¼Æ¤£¾A¥Î¡C

°ÝÃD18.rar (7.38 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 3# s7659109
B2°}¦C¤½¦¡
=MIN(IF(¸ê®Æ!$B$2:$B$21>=µ²ªG!A2,¸ê®Æ!$B$2:$B$21,""))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤j¤j¡G
¯Å¶Z¶i¤Æª©½Ð±Ð¡A·í¿é¤J­È¤j©ó¯Å¶Z³Ì¤j­È®É¡Aµª®×Äæ
¤£·|¿ï¯Å¶Z³Ì¤j­È¡C

°ÝÃD18-1.rar (7.93 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 5# s7659109

¬O³o¼Ë¶Ü?

=-LOOKUP(-MIN(A2,MAX(¸ê®Æ!B$2:B$21)),SMALL(-¸ê®Æ!B$2:B$21,ROW($1:$20)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥i¥H¥Î¤F¡A¦ýÁÙ¦³¤@ÂI½Ð¨D¡A·í¨ì³Ì°ª¯Å¶Z©³¦â¥H¯»¬õ¦âªí¥Ü¡A½Ð°Ý¸Ó¦p¦ó­×¥¿¡H

°ÝÃD18-2.rar (8.06 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 7# s7659109

> ·í¨ì³Ì°ª¯Å¶Z©³¦â¥H¯»¬õ¦âªí¥Ü¡A½Ð°Ý¸Ó¦p¦ó­×¥¿¡H

¤½¦¡¤£¥Î­×§ï

­n¥t³] ³]©w®æ¦¡¤Æ±ø¥ó
¥ý¿ï B2:B12
³]©w®æ¦¡¤Æ±ø¥ó¡A·s¼W - ¨Ï¥Î¤½¦¡...
¤½¦¡ =B2=20000
®æ¦¡ - ³]©w - ¶ñº¡ - ¿ïÃC¦â
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·P·Å°Õ!¤j¤j
§Æ±æ¤ä«ù!

TOP

¦ý¤´·Q¡A¥i§_¦b­ì¨ç¼Æ¤¤ª½±µ§PÂ_¡C
§Æ±æ¤ä«ù!

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD