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

[µo°Ý] ¬O§_¥i§PÂ_Àx¦s®æªº±ø¥ó©Î¬O¼g¥X§PÂ_²[¼Æ

[µo°Ý] ¬O§_¥i§PÂ_Àx¦s®æªº±ø¥ó©Î¬O¼g¥X§PÂ_²[¼Æ

°ÝÃD¦p¤U:

1. §P©wA1Àx¦s®æ¤º¡A¬O§_¥]§t PC (­Y¦³ "-" ¬O§_¥i§PÂ_?)

2. §P©wA9:A300  ¡A¨C®æªº¦r¤¸¼Æ¬O§_µ¥©ó 6

3. §P©wD8Àx¦s®æ¤º¡A¬O§_µ¥©ó NOMINAL ©Î¬O ¼Ð·Ç­È

4. §P©wI8Àx¦s®æ¤º¡A¬O§_µ¥©ó DEV ©Î¬O °¾®t

¨Ì§Ç1-4°µÀˬd¡A¨C¤@ÂI§¹¦¨¡A·|¶]¥Xµøµ¡½T»{OK

¦^´_ 2# bsy4life


·PÁÂ bsy4life ¤j¤j
§Ú¤w¸g¥Î¥¨¶°¼g¥X¤F

TOP

1. §P©wA1Àx¦s®æ¤º¡A¬O§_¥]§t PC (­Y¦³ "-" ¬O§_¥i§PÂ_?)
=IF(COUNTIF(A1,"PC*"),"OK","")
2. §P©wA9:A300  ¡A¨C®æªº¦r¤¸¼Æ¬O§_µ¥©ó 6
³o­Ó³¡¥÷§Ú¥u°µ¨ì³æµ§¡A³Ñ¤U¬Ý¦³¨S¦³¨ä¥L«e½ú¥i¥HÀ°¦£êy
=IF(LEN(A9)=6,"OK","")   
3. §P©wD8Àx¦s®æ¤º¡A¬O§_µ¥©ó NOMINAL ©Î¬O ¼Ð·Ç­È
=IF(OR(D8="NOMINAL",D8="¼Ð·Ç­È")=TRUE,"OK","")
4. §P©wI8Àx¦s®æ¤º¡A¬O§_µ¥©ó DEV ©Î¬O °¾®t
=IF(OR(I8="dev",I8="°¾®t")=TRUE,"OK","")

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD