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

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

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

TOP

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

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

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD