Àx¦s®æ¤½¦¡¥X²{¿ù»~:¤½¦¡¬Ù²¤¬Û¾FªºÀx¦s®æ
- ©«¤l
- 14
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 52
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2014-5-7
- ³Ì«áµn¿ý
- 2015-5-11
|
À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
|
|
|
|
|
- ©«¤l
- 41
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2014-7-27
- ³Ì«áµn¿ý
- 2021-5-22
|
¥»©«³Ì«á¥Ñ 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)
À³¸Ó¬On³o¼Ë?! ¸Õ¸Õ¬Ý «¢«¢«¢
¤S©ÎªÌ ק令
=IF(B2=2,MAX($C$1:$C$5),2)
=IF(B3=3,MAX($C$1:$C$5),2) |
|
Cyssuc
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 52
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2014-5-7
- ³Ì«áµn¿ý
- 2015-5-11
|
¦^´_ 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
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-28 09:53 ½s¿è
¦^´_ 3# ³\·ç²»
¨Ì1#»P3#ªº´yz¬Ý¨Ó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¡AY¬O¨Ì§Ç¼Æ¦C¡A«h¥i³w¥ÎB2=ROW(1:1)+1¡A¦V¤U½Æ»s¤½¦¡¸Ñ¨M¡C |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 52
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2014-5-7
- ³Ì«áµn¿ý
- 2015-5-11
|
¦^´_ 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
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-29 09:23 ½s¿è
¦^´_ 6# ³\·ç²»
±zªº°ÝÃDì¦]½Ð°Ñ¦Ò5#¶W¯Åª©¥DHsiehªº»¡©ú»P×¥¿ |
|
|
|
|
|
|