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

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

¦^´_ 1# lcctno


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

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

¦^´_ 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

¦^´_ 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

¦^´_ 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

¦^´_ 11# lcctno

¦]¬°DÄ榳±Æ§Ç ¤p¦Ü¤j
§ä<=O6¤§­È¡Aª½±µ¥Îlookup¨ç¼Æ´N¥i
=LOOKUP(O6,D$3:D$1026)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD