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

[µo°Ý] ¦³¤½¦¡¤§Àx¦s®æªÅ¥Õ°ÝÃD½Ð±Ð

[µo°Ý] ¦³¤½¦¡¤§Àx¦s®æªÅ¥Õ°ÝÃD½Ð±Ð

DEAR ALL ¤j¤j
1.Àx¦s®æA1ªÅ¥Õ :¨Ï¥Î  =IF(OR(A1="",A1= " "),TRUE,FALSE) ¥i¥¿±`§PÂ_ ªÅ¥Õ=TRUE
2.¦ý·íÀx¦s®æA1¦³¤º«Ø¤½¦¡ AND Àx¦s®æA1¤½¦¡µ²ªG=ªÅ¥Õ®É
2.1¨Ï¥Î  =IF(OR(A1="",A1= " "),TRUE,FALSE) ¥X²{  µ²ªG  FALSE
3.½Ð°Ý¦p¦ó§PÂ_  Àx¦s®æA1¦³¤º«Ø¤½¦¡ AND Àx¦s®æA1¤½¦¡µ²ªG=ªÅ¥Õ ®É¨q¥X  TRUE
                             Àx¦s®æA1¦³¤º«Ø¤½¦¡ AND Àx¦s®æA1¤½¦¡µ²ªG=«DªÅ¥Õ ®É¨q¥X  FALSE
4.·Ð¤£§[½ç±Ð  THANKS*10000
ù

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD