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

[µo°Ý] ½Ð°Ý ¦p¦ó¨Ï¥Î¤½¦¡±N°Ñ·Ó¤§­È±a¤J Part 2

[µo°Ý] ½Ð°Ý ¦p¦ó¨Ï¥Î¤½¦¡±N°Ñ·Ó¤§­È±a¤J Part 2

¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-9 21:38 ½s¿è

¦p¹Ï ½Ð°Ý¨º4­Óµµ¦â¤§ªÅ®æ¤º¸Ó¦p¦ó¿é¤JEXCELL¤§¤½¦¡ ¤~¯à±o¨ì³Ì±µªñ¤§¹ïÀ³­È
ÁöµM¤w¦³°ª¤â ML089 ¶Q¤H±Ð¹L§ÚÃþ¦üªº±¡§Î ¦ý§Ë¤F6-7¤p®ÉÁÙ¬O¨S§¹¦¨¤°»ò §Ú¯uªº¬OµL¯à µLªkÁ|¤@¤Ï¤T ÁٽжQ¤H¬Û±Ï
¦b¦¹ÁÂÁ±zªº¥Î¤ß»P°Ñ»P







test2.zip (39.71 KB)

¦^´_ 1# lcctno


    ³Ì±µªñ¹ê»Ú²Î­p«ü¼Æ.rar (24.89 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-9 22:43 ½s¿è

¦^´_ 2# ML089

±z°Ê§@ÁÙ¯u§Ö ­è­è¶XªÅ¥h¦Y¿ð¨Óªº±ßÀ\(§Ë¨ì¨S®É¶¡¦Y) ±z¤W¶Çªº¤º®e ¥i¯à§Ú¨S»¡ªº«Ü²M·¡³y¦¨¦³·L¤pªº®t¶Z
¨Ò¦p 7,735 À³¸Ó¬O¹ïÀ³©ó 7730  62.256% ¦Ó«D¬O 7740   62.522%
85.00% À³¸Ó¬O¹ïÀ³©ó 84.808%  8780 ¦Ó«D¬O 85.01  8790
§Ú·QÁÙ¬O½Ð±z¨ÓÀ°§Ú¸Ñ¨M ¤£µMªº¸Ü§Ú¥i¯à§Ë¨ì¥b©]¤]µL¸Ñ ¥ýÁÂÁ±z¤F

TOP

¦^´_ 3# lcctno


¨Ò¦p
7,735 À³¸Ó¬O¹ïÀ³©ó 7730  62.256% ¦Ó«D¬O 7740   62.522%
85.00% À³¸Ó¬O¹ïÀ³©ó 84.808%  8780 ¦Ó«D¬O 85.01  8790

7735 »P7730¤Î7740³£¬O®t5¡A±NMAX§ï¬°MIN´N¥i¥H¡C
P4 {=MIN(IF(ABS(A3:A1026-O4)=MIN(ABS(A3:A1026-O4)),A3:A1026))}
Q4 {=MIN(IF(ABS(A3:A1026-O4)=MIN(ABS(A3:A1026-O4)),D3:D1026))}


85-84.808 = 0.192
85.01-85 = 0.01
85.01¤ñ¸û±µªñ85
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089

¸ÑÄÀ¬°¦ó   "85.00% À³¸Ó¬O¹ïÀ³©ó 84.808%  8780 ¦Ó«D¬O 85.01  8790 "
¦]¬°¬O¨Ï¥Î©ó¸êª÷°t¸mªº³W¹ºÁʶRªÑ²¼¤è®× ÁöµM85.01%¬O³Ìªñ¤§­È ¦ý¨º¼Ë¥i¯à·|¦h³y¦¨¦hªá¶O¿úÁʶR ¦ý¨S¿ú¤F´N¬O¨S¿úÁʶR ±z»¡©O?
¥t¥~ÃD¥~¸Ü ¾Ú»¡"85%ª±ªÑ²¼¤§¤H¬O¿é®a" ©Ò¥H¤£¯à°¨ªêµø¤§
·PÁ¤§¥~ÁÙ¬O·PÁ ÁÂÁ±zªºÀ°¦£

TOP

¦^´_ 5# lcctno

85-84.808 = 0.192
85.01-85 = 0.01
85.01¤ñ¸û±µªñ85

©Î³\¥i¥H¥Î 85¢H©ó¤½¦¡­pºâ®É­°§C0.2¢H¥H84.8¢H¨Ó³B²z


PS¡G¥xÆW´²¤á¦h©Ò¥H¬O85¢H¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089
²×©ó§¹¦¨¤F ¦ý»yªk¦n¹³¤£¨Î(¤º®e«Üªø) ¬Ý±z¯à§_À°¦£Â²¤Æ ÁÂÁ±z¤F




test2.zip (39.91 KB)

TOP

¦^´_ 7# lcctno


P6 {=MIN(IF(ABS(D3:D1026-O6+0.2%)=MIN(ABS(D3:D1026-O6+0.2%)),D3:D1026))}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089

P6 {=MIN(IF(ABS(D3:D1026-O6+0.2%)=MIN(ABS(D3:D1026-O6+0.2%)),D3:D1026))}
ÁÂÁ±zªº¥Î¤ßÀ°§U§Ú²¤Æ¤½¦¡ ¦ý¤W­±ªº¤½¦¡¨ÃµLªk¾A¥Î©ó¥ô¦ó¿é¤J©óO6¤§­È ½Ð¬Ýªþ¥ó

PS. O6¤§­È¬O¥ô·N­È  ¨Ã«D¥u¾A¥Î©ó¯S©w­È(85%)




test2.zip (40.6 KB)

TOP

¦^´_ 9# lcctno


84.808%
85.006%
85.188%

¿é¤J85% §ä¨ì84.808
¿é¤J85.18% §ä¨ì 85.188%
´N¬O§ä¤p©ó¸Ó­Èªº¥Ø¼Ð¡A¨Ã¤£¬O§ä³Ì±µªñ­È

­Y¿é¤J85.006%®É¡A¬O­n§ä¨ì85.006%©Î84.808% ?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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