ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD