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

[µo°Ý] ­û¤u¯S¥ð­pºâ

[µo°Ý] ­û¤u¯S¥ð­pºâ

¤£¦n·N«ä~§Æ±æ§â¯S¥ð­pºâ¥HEXCELªº¤è¦¡¼g¥X¡A¦³¶îÃC¦âªº®æ¤l¬O¬°¿é¤J¤½¦¡®æ¡A¥H¦b¾¦~¸ê©Ò±a¥X¥»¦~«×¥i¥ðªº¯S¥ð¡F­Y¬OÂ÷¾ªº¸Ü¡A¤]§Æ±æ¥i¥H­pºâ¥X¹ê»Ú¤WÀ³¦³ªº¯S¥ð®É¼Æ¡A¥H«K±oª¾¬O§_¦³¶W¥ðªº±¡§Î~


¯S¥ð­pºâ.zip (3.04 KB)

e2=IF(C2>10,14+INT(C2-10),LOOKUP(C2,{0,3,5,10},{0,7,10,14}))

TOP

¦^´_ 1# jessicawu

¥Ñ©ó C2 ¦~¸êªº®æ¦¡¨Ã«D¾ã¼Æ¡A¨Ã¥B¨Ï¥Î NOW ¨ç¼Æ¡C¨Ï¥Î LOOKUP ¨t¦Cªº¨ç¼Æ·|¦³Áͪñªº°ÝÃD¡A©Ò¥HÁÙ¬O±Ä¥Î¤Fªí®æ°Ñ·Ó¡C

¯S¥ð­pºâ.zip (3.71 KB)

TOP

Angela¤j¤j,ÁÂÁ±zªº¸ÑµªËç~ªì¨B¤W¤F¸ÑÅo!Lookup³o¥\¯à§Ú­Ë¬O«Ü¤Ö¥Î¨ì¡A¤j³¡¥÷³£¬O¨Ï¥Îvlookup¡A¦ý¬O­Ë¤£ª¾¬°¦ó¨Ï¥Î{ }©O?

Eugene¤j¤j,¯u¤£¦n·N«ä¬Ý¤£¨ì±zªºªþ¥ó...°¸¯À¤p¾Ç¥Í...

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-8-5 12:10 ½s¿è

¦^´_ 4# jessicawu


    LOOKUP ¨ç¼Æ·|±q³æ¦C¡B³æÄæ½d³ò (½d³ò:¤u§@ªí¤Wªº¨â­Ó©Î¦h­ÓÀx¦s®æ¡C½d³ò¤¤ªºÀx¦s®æ¥i¥H¬Û¾F©Î¤£¬Û¾F¡C)©Î±q°}¦C (°}¦C:¥Î¨Ó«Ø¥ß²£¥Í¦h­Óµ²ªG©Î¹Bºâ¤@²Õ¥H¦C¤ÎÄæ±Æ¦C¤§¤Þ¼Æªº³æ¤@¤½¦¡¡C°}¦C½d³ò¦@¥Î¤@­Ó¤½¦¡¡F¤@­Ó°}¦C±`¼Æ¬O¥Î§@¤@­Ó¤Þ¼Æªº¤@²Õ±`¼Æ¡C)¶Ç¦^¤@­Ó­È¡CLOOKUP ¨ç¼Æ¦³¨âºØ»yªk§Î¦¡¡G¦V¶q§Î¦¡»P°}¦C§Î¦¡¡C

LOOKUP(C2,{0,3,5,10},{0,7,10,14)
c2ªº­È>=0,<3,¶Ç¦^°}¦Cªº²Ä¤@­Ó­È 0
c2ªº­È>=3,<5,¶Ç¦^°}¦Cªº²Ä¤G­Ó­È7
>=5,<10,¶Ç¦^10
>=10,¶Ç¦^14

TOP

¶â~~¤F¸Ñ~~µ¥¦P©ó°}¦Cªº¤è¦¡...¥i¯àÁٻݭn¤@ÂI®É¶¡®ø¤Æ¤@¤U!ÁÂÁÂËç~~

TOP

¥»©«³Ì«á¥Ñ Eugene ©ó 2011-8-5 15:16 ½s¿è

¦^´_ 4# jessicawu

E2=IF(TRUNC(C2)>25,30,VLOOKUP(TRUNC(C2),$N$2:$O$27,2,0))

¥Ñ©ó Microsoft Excel »¡©ú¤¤¡G¦pªG LOOKUP ¨ç¼ÆµLªk§ä¨ì lookup_value¡A¥¦·|±Ä¥Î°}¦C¤¤µ¥©ó©Î¤p©ó lookup_vector ªº³Ì¤j­È¡C
©Ò¥H¡A·s¼W¤F¤@­Óªí®æ¡G

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-8-5 16:04 ½s¿è

E2=VLOOKUP(min(25,TRUNC(C2)),$N$2:$O$27,2,0))
E2=VLOOKUP(C2,$N$2:$O$27,2,1)
À³¸Ó¥i¥H±o¨ì¬Û¦Pµª®×
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

=LOOKUP(C2,{0,1,3,5,10},{0,7,10,14,15})+MAX(0,MIN(15,INT(C2)-10))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

=LOOKUP(C2,{0,1,3,5,10},{0,7,10,14,15})+(C2>10)*INT(C2-10)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD