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

[µo°Ý] ¦p¦ó±NÄæ¦ì¼Æ­ÈÂà´«¦¨·s¼Æ­È

[µo°Ý] ¦p¦ó±NÄæ¦ì¼Æ­ÈÂà´«¦¨·s¼Æ­È

¥»©«³Ì«á¥Ñ 074063 ©ó 2011-8-10 15:51 ½s¿è



¦³¤°»ò¤½¦¡¥i¥H§âA~EÄ檺¼Æ­È¦b·sÄæ¦ì

Âà´«¦¨1=2,2=4,3=3,4=2,5=1ªº·s¼Æ­È

Q1.rar (1.86 KB)

=LOOKUP(A1,{1,2,3,4,5},{2,4,3,2,1})

TOP

¦^´_ 1# 074063


    =IF(A1<3,A1*2,IF(A1>3,A1-(A1-3)*2,A1))

TOP

·PÁÂANGELAª©¥D¤j¤j¼ö¤ßªº¸Ñµª ^^

infoverdad¤j¤jªº¸Ñµª¦ü¥G¤£¯à®M¥Î~ ¤£¹LÁÙ¬OÁÂÁ§A^^

TOP

¦^´_ 4# 074063


    ¦pªG¤£¥Î¨ç¼Æ§ï¥Î¼Æ¾Ç¤½¦¡±a¤Jªº¸Ü  ½Ð°Ý¼Æ¾Ç¤½¦¡­n«ç»ò¤U

TOP

=(A1=1)*2+(A1=2)*4+(A1=3)*3+(A1=4)*2+(A1=5)*1

TOP

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-8-10 23:17 ½s¿è

¦^´_ 4# 074063
¦^´_ 6# ANGELA


   §Ú¸Õ³o¤TºØ¤èªkµª®×³£¤@­P£«!!
   ¤£¹L,Angelaª©¤jªº¤½¦¡ªº½T®¼Ægªº, ¤S¾Ç¨ì¤F!!
   ÁÂÁª©¤j.

TOP

¦^´_ 6# ANGELA


    ANGELA¤j¤j

­Y¨Ì¦¹­ì«h¡ALookup¬O§_¬Ò¥i¦p¦¹ÅܤÆ

­Y¹J¨ì¤å¦r¬O§_¤]¥i¥H©O?

TOP

¦^´_ 8# jimmuLu


    ¤å¦r¼Æ¦r³£¥i¥Î,lookup¬OµLªk¬Ò¥Î¼Æ¾Ç¹Bºâ¦¡¨ú¥Nªº.
   ¤£¹L¦³®É¹Bºâ¦¡¤]®¼¤è«Kªº
    ³]a1¤j©ó b1«hc1=5
        b1¤j©óa1«hc1=0

        c1 =if(a1>b1),5,0)
        c1 =(a1>b1)*5

TOP

=CHOOSE(A1,2,4,3,2,1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD