ªð¦^¦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 : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD