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

½Ð°Ý¦b¤T¬ì´úÅ礤¡A¦p¦ó¿ï¥X¦³¨â¬ì¥H¤W¤£¦X®æªÌ

½Ð°Ý¦b¤T¬ì´úÅ礤¡A¦p¦ó¿ï¥X¦³¨â¬ì¥H¤W¤£¦X®æªÌ

¥»©«³Ì«á¥Ñ sujiuanjiuan ©ó 2010-12-22 11:22 ½s¿è

½Ð°Ý¦b¤T¬ì´úÅ礤¡A¦p¦ó¿ï¥X¦³¨â¬ì¥H¤W¤£¦X®æªÌ
¨Ò¦p¦Ò¸Õ¦³°ê­^¼Æ¤T¬ì¡A
­n§â¦³¨â¬ì©Î¤T¬ì¤£¤Î®æªº¾Ç¥Í§ä¥X¨Ó
¤T¬ì³£¤£¤Î®æ¥i¥H¥Î{=IF((C5<60)*(D5<60)*(E5<60),B5,"")}
¨â¬ì©Î¨â¬ì¥H¤W¤£¦X®æ­n«ç»ò°µ©O¡H
aaa.zip (6.67 KB)
·s¤â¾Çexcel

=IF(COUNTIF(C1:E1,"<60")>=2,B1,"")
¨S¨Æ´N¨Ó³}³}

TOP

=IF((C5<60)+(D5<60)+(E5<60)>=2,B5,"")

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD