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

[µo°Ý] IF(OR...°ÝÃD

[µo°Ý] IF(OR...°ÝÃD

½Ð±Ð¤j¤j:
D8= if D11:D100 ¦³Dªº¼Æ¦r¡A¤Ö¹L6­Ó¡A´N¼Æ¥X¦P®É¦³2©M3Dªº¦¸¼Æ¡A©Î if D11:D100 ¦³Dªº¼Æ¦r¡A¦h¹L5­Ó¡A´N¼Æ¥X¦P®É¦³2©M6Dªº¦¸¼Æ¡C
TEST1.rar (4.07 KB)

¥»©«³Ì«á¥Ñ cdkee ©ó 2016-8-4 10:15 ½s¿è

¸Õ¤F¥H¤U¡A½Ð±Ð¤j¤jÀ³¸Ó¦p¦ó§ï¡AÁÂÁÂ!
D8=IF(COUNTIF(D$11:D$100,"*D")<6,IF(AND(COUNTIF(D$11:D$100,"2"),COUNTIF(D$11:D$100,"3D")),1,IF(COUNTIF(D$11:D$100,"*D")>5,IF(AND(COUNTIF(D$11:D$100,"2"),COUNTIF(D$11:D$100,"6D")),1,""))),"")

TOP

¦P®É¦³2©M3Dªº¦¸¼Æ
¦P®É¦³2©M6Dªº¦¸¼Æ
³o¬O¤°»ò·N«ä?
2*3D*
2*6D*
³o¼ËªºÀx¦s®æ?

TOP

=MIN(COUNTIF(D11:D100,2),COUNTIF(D11:D100,IF(COUNTIF(D11:D100,"*d*")<6,"3d","6d")))

TOP

¦^´_ 4# ­ã´£³¡ªL

ÁÂÁ­㴣³¡ªLª©¤j¡A¥i¥H¤F!

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD