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

·s¤â¡A¦³EXCEL°ÝÃD

·s¤â¡A¦³EXCEL°ÝÃD

­Y§Ú©óA1¥´¤W¤å¦rA¡A¦bB1®æ¥´¤W¤½¦¡=IF(A1="A","A" ,"0")¡Aµª®×¬OA ­Y§Ú©óA1¥´¤WB,¦bB1®æ·|¥X²{0¡A­Y§Ú·QA1®æ¥´A©ÎB¡A¦bB1®æµª®×¬OA,©ÎB¡A¨ä¥L´N¥X²{0¡A§Ú¸Õ¹L=IF(A1="A","A","0")&(A1="B","B","0")¡A¤£¦¨¥\¡A½ÐÀ°¦£?

¥»©«³Ì«á¥Ñ KCC ©ó 2016-7-14 14:03 ½s¿è

¦^´_ 1# lesaux001

   
    ¤£¤À¤j¤p¼g¡AA1¥´a©ÎA¡A³£·|¥X²{A
     B1=IF(A1="A","A",IF(A1="B","B",0))
    ¤À¤j¤p¼g, A1 ¥´ A ¤~·|¥X²{ A
    B1=IF(EXACT(A1,"A"),"A",IF(EXACT(A1,"B"),"B",0))

TOP

¦^´_ 1# lesaux001

­Y§Ú·QA1®æ¥´A©ÎB¡A¦bB1®æµª®×¬OA,©ÎB¡A¨ä¥L´N¥X²{0¡A§Ú¸Õ¹L=IF(A1="A","A","0")&(A1="B","B","0")¡A¤£¦¨¥\¡A½ÐÀ°¦£?

=IF(COUNT(FIND(A1,"AB")),A1,"0")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD