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

[µo°Ý] ±±¨î ¥²¶ñÀxÂÃ®æ ¨S¶ñ¥X²{ĵ§i ¶ñ§¹¾ã«á A1-E1 ¶ñº¡ÃC¦â

[µo°Ý] ±±¨î ¥²¶ñÀxÂÃ®æ ¨S¶ñ¥X²{ĵ§i ¶ñ§¹¾ã«á A1-E1 ¶ñº¡ÃC¦â

±±¨î ¥²¶ñÀxÂî栠A1  B1  D1 E1 ¥²¶ñ  ¨S¶ñ¥X²{ĵ§i  ¶ñ§¹¾ã«á A1-E1 ¶ñº¡ÃC¦â
«ç¼Ë¯à¹F¦¨ ³o¼Ë¥\¯à©O
HI

¥»©«³Ì«á¥Ñ ´å·à ©ó 2010-10-17 19:10 ½s¿è

¤ñ¦p说¡P ¦b C1 ¨½输¤J¤½¦¡=IF(OR(A1="",B1="",D1="",E1=""),"½Ð¶ñ¤W","ÁÂÁ¦X§@")

ÃC¦â¼Ð°O¡G±ø¥ó®æ¦¡¡n¥u®æ¦¡¤Æ¥]§t¤U¦CªºÀx¦s®æ¡n

Àx¦s®æ=$A$1,$B$1,$D$1,$E$1



§Úªº¬O­^¤åª©¡A«_¬N­É¥ÎÁ¤j¤jªº¹Ï¤ù¤@±i¥H¨Ñ°Ñ¦Ò¡C

TOP

ÁÂÁ ÁöµM¤£¤jÀ´  ¸Õ¤FÁÙºâOK ¦ý¤£¬O§Ú¥Ø¼Ð
¦]¬°¤@¨Ç§Ú¤£·|¥Î
Àx¦s®æ=$A$1,$B$1,$D$1,$E$1   §Ú§ä¤£¨ì¦a¤è ¿é¤J
§Úªº§@ªk  ³]©w®æ¦¡¤Æ±ø¥ó>>·s¼W³W«h>>¥u®æ¦¡¤Æ¤U¦CÀx¦s®æ   Àx¦s®æ­È  «DªÅ®æ
§ÚºCºCºN¯Á  À³¸Ó·|À´§Aªº·N«ä  ÁÂÁÂ
HI

TOP

³]©w®æ¦¡¤Æ±ø¥ó>>·s¼W³W«h>>¨Ï¥Î¤½¦¡¨Ó¨M©w­n®æ¦¡¨º¨ÇÀx¦s®æ
=AND($A1<>"",$B1<>"",$E1<>"",$D1<>"")

TOP

¦^´_ 4# ANGELA
   ÁÂÁ§A ¤S¦h¾Ç¤@Ä_
HI

TOP

­É¥ÎANGELA¥Sªººc·Q
®æ¦¡¤Æ³W«h¦p¤U
=COUNTA($A4:$E4)-($C4<>"")=4

TOP

¦^´_ 6# toomellowhaw


¥H toomellowhaw ¥S¤½¦¡¦A²¤Æ
=COUNTA(A1,B1,D1,E1)=4
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 7# asimov


¶â¶â..­ì¨Ó¦p¦¹..
¬O§Ú·Q½ÆÂø¤F..·P®¦..¦hÁ«ü±Ð..

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD