- ©«¤l
- 14
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- XP, Vista & Window7
- ³nÅ骩¥»
- Office 2003 & 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-16
- ³Ì«áµn¿ý
- 2023-5-30
|
¥»©«³Ì«á¥Ñ 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
|
|