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

Àx¦s®æ¤½¦¡¥X²{¿ù»~:¤½¦¡¬Ù²¤¬Û¾FªºÀx¦s®æ

Àx¦s®æ¤½¦¡¥X²{¿ù»~:¤½¦¡¬Ù²¤¬Û¾FªºÀx¦s®æ

B2=2             B3=3
¦bC1:C5=1,2,3,4,5¦pªþ¥ó
¦bK7Àx¦s®æ¤½¦¡ =IF(B2=2,MAX(C1:C5),2)
¦bK8Àx¦s®æ¤½¦¡ =IF(B3=3,MAX(C2:C5),2)
½Ð°Ý¤j¤j¬°¤°»òK7Àx¦s®æ¨S¦³¿ù»~    K8«o·|¦³   
       ·PÁÂ~~
123.rar (17 KB)
¤j®a¤¬¬ÛÀ°¦£¸Ñ¨M°ÝÃD,¤~·|¶i¨B

¥»©«³Ì«á¥Ñ Cyssuc ©ó 2014-7-27 19:53 ½s¿è

½MÙT¤@¤U
§Ú¤£¯à¬Ýªþ¥ó
¦bK7Àx¦s®æ¤½¦¡ =IF(B2=2,MAX(C1:C5),2)
¦bK8Àx¦s®æ¤½¦¡ =IF(B3=3,MAX(C2:C5),2)

K8Àx¦s®æ¤½¦¡ =IF(B3=3,MAX(C1:C5),2)
À³¸Ó¬O­n³o¼Ë?!  ¸Õ¸Õ¬Ý «¢«¢«¢

¤S©ÎªÌ ­×§ï¦¨
=IF(B2=2,MAX($C$1:$C$5),2)
=IF(B3=3,MAX($C$1:$C$5),2)
Cyssuc

TOP

¦^´_ 2# Cyssuc


    ÁÂÁ¤j¤j  ¦³¸Ñ¨M§Úªº°ÝÃD
¦pªGK8=IF(B3=3,MAX($C$2:$C$5),2)  §ï¦¨³o­Ó¼Ë¤l¦³¸Ñ¨M§Úªº°ÝÃD
¦ý¬O   ¦]¬°§Ú¾ã­ÓCÄ榳¼Æ­È      §Ú·QÅýK8=IF(B3=3,MAX(C2:C5),2)     K9=IF(B4=4,MAX(C3:C6),2)   K9=IF(B5=5,MAX(C4:C7),2)
¥H¦¹Ãþ±À  ¶ñ¥R¤U¥h     ´N¤£¯à¥Î"µ´¹ï°Ñ·Ó"¡÷MAX($C$2:$C$5)
¬°¤°»ò·|³o¼Ë!?   ½Ð¤j¤jÀ°§Ú¸Ñµª
¤j®a¤¬¬ÛÀ°¦£¸Ñ¨M°ÝÃD,¤~·|¶i¨B

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-28 09:53 ½s¿è

¦^´_ 3# ³\·ç²»
¨Ì1#»P3#ªº´y­z¬Ý¨ÓMAXªº¤Þ¼Æ¦³¨Ç¥Ù¬Þ¡A¥i§_¤W¶ÇCÄæ§t¦hµ§¸ê®Æ¥Bªþ¤W±z´Á«Ýªºµª®×¤§½d¨ÒÀɨѰѡH¤è«K¬ã¨s¡I
ÁÂÁ¡I
[µù1]
1#¡G¦bK7Àx¦s®æ¤½¦¡ =IF(B2=2,MAX(C1:C5),2)¡F¦bK8Àx¦s®æ¤½¦¡ =IF(B3=3,MAX(C2:C5),2)
3#¡GK8=IF(B3=3,MAX(C2:C5),2)     K9=IF(B4=4,MAX(C3:C6),2)   K9=IF(B5=5,MAX(C4:C7),2)
[µù2]
¤W¦C¤½¦¡¤§B2=2¡BB3=3¡BB4=4¡BB5=5¡A­Y¬O¨Ì§Ç¼Æ¦C¡A«h¥i³w¥ÎB2=ROW(1:1)+1¡A¦V¤U½Æ»s¤½¦¡¸Ñ¨M¡C

TOP

¦^´_ 3# ³\·ç²»
¨Ì§Aªº±Ô­z¡A¥u¬O¿ù»~Àˬdµo²{¬Û¾FÀx¦s®æ¤½¦¡¤£¤@­P
¦Ó¤£¬O¤½¦¡­pºâ¿ù»~
¥u»Ý©¿²¤¸Ó¶µ¤½¦¡Àˬd§Y¥i

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# p212

¥¦ªº¼Æ­È¬O¥¿½Tªº,¥u¬OK7:K16ªºÀx¦s®æ¥ª¤W¨¤·|¥X²{ºñ¦â¤T¨¤§Î,¦¹Àx¦s®æ¤ºªº¤½¦¡°Ñ·Ó¨ì»P¨ä¥L¼Æ­È¬Û¾Fªº½d³ò
¥u¬Oı±o«Ü©_©Ç¬°¤°»ò·|¦³³o°ÝÃD
    CÄæ§t¦hµ§¸ê®Æ.rar (18.86 KB)
¤j®a¤¬¬ÛÀ°¦£¸Ñ¨M°ÝÃD,¤~·|¶i¨B

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-29 09:23 ½s¿è

¦^´_ 6# ³\·ç²»
±zªº°ÝÃD­ì¦]½Ð°Ñ¦Ò5#¶W¯Åª©¥DHsiehªº»¡©ú»P­×¥¿

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD