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

¥[¯Z¶O¦p¦ó­pºâ¡H

¥[¯Z¶O¦p¦ó­pºâ¡H

¥Ñ©ó¨C¦ì­û¤u¥[¯Z¶O§¡¤£¤@¡A¦¹¥[¯Z¶O­n¦p¦ó³]¤½¦¡©O¡H

ÁÂÁ¡I

¥[¯Z¶O.rar (8.45 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-5-3 11:44 ½s¿è

¦^´_ 1# q1a2z5
C2=INT(SUMPRODUCT(FREQUENCY(ROW(INDIRECT("A1:A"&B2)),{8,10}),{183.16;243.61;304.05}))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ§Aªº¸Ñµª,
¥i§_±N·í¤é¥[¯Z®É¼Æ¤Îª÷ÃB§@¢²ºØ°Ï¤À¡H
ÁÂÁ¡I

¥[¯Z¶O-1.rar (9.44 KB)

TOP

¦^´_ 3# q1a2z5
«e8¤p®É¤p®É¼Æ
D2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),1)
9~10¤p®É¤p®É¼Æ
F2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),2)
11¤p®É¥H«á¤p®É¼Æ
G2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),3)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

¬O»¡¦pªG¤À¶}¨Ó³B²zªº¸Ü¡A¨ä¹ê¥Î²³æªºif§PÂ_§Y¥i
D2=IF(C2>8,8,C2)  «e8¤p®É
F2=IF(C2>10,2,IF(C2>8,C2-8,0))  9~10¤p®É
G2=IF(C2>10,C2-10,0)  10¤p®É¥H«á

TOP

¦^´_ 3# q1a2z5

D2 =MIN(C2,8)
F2 =C2-D2-G2
G2 =MAX(C2-10,0)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ±оǡA¯uªºª¾¹D¤F

TOP

http://blog.xuite.net/hcm19522/twblog/404664224
D2:D4=INT(SUM(--TEXT((B2-{0,8,10})*{183.16,60.45,60.44},"0.00;!0")))

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD