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

ExcelÀx¦s®æ¹ï·Ó°ÝÃD

ExcelÀx¦s®æ¹ï·Ó°ÝÃD

¼ÐÃD°Ýªº¤£¦n,½Ð¨£½Ì.¸Ô²Ó½Ð°Ñ·Óªþªí

°ÝÃD: ­Y A2=sub,«h±NB2ªºrating (twAA)¹ïÀ³¨ì rating table ¦ì¸mªº¤U¤@¦C¨ú±o¸ê®Æ(¥ç§Y¬O¦bC2Åã¥ÜtwAA-),§_«h´N¤´ªu¥ÎB2ªºrating(twAA)

½Ð°Ý¦U¦ìCÄ檺¤½¦¡À³¸Ó«ç»ò¼g?ÁÂÁÂ

book1.zip (2.46 KB)
Jeffrey Chen

=IF(A2="SUB",LOOKUP(2,1/($E$2:$E$6=B2),$E$3:$E$7),B2)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-2-17 23:09 ½s¿è

ÁÂÁ©p!Angela¤j
¥i§_½Ð©p¸ÑÄÀ¤@¤U¤½¦¡¤º"1/($E$2:$E$6=B2"ªº·N«ä°Ú?§Ú¹ê¦b¬Ý¤£¤ÓÀ´
Jeffrey Chen

TOP

TOP

ÁÂÁÂ,ÁöµMÁÙ¤£¬O«ÜÀ´,¦ý§Aµ¹§Ú¤F¤@­Ó«Ü¦nªº¤è¦V.
Jeffrey Chen

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD