ªð¦^¦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.jpg
2015-8-9 21:36



test2.zip (39.71 KB)

¦^´_ 12# ML089



°ª¤â¯uªº¬O°ª¤â ¯uªºÂ²¤Æ«Ü¦h¤F ¥B­È¤S¥¿½T ³£©Ç§Ú¨S»¡²M·¡ ®`±z®ö¶O¤F¨º»ò¦h®É¶¡ ²{±Nµ²ªG¤W¶Ç¤W¨Ó ¥i¥H¤è«K·í§O¤Hªº½d¨Ò ¯uªº«D±`·PÁ±zªº¨¯³Ò»P­@¤ßªº¥I¥X ¨¯­W±z¤F






test2.zip (40.96 KB)

TOP

¦^´_ 11# lcctno

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

TOP

¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-10 20:19 ½s¿è

¦^´_ 10# ML089
¤£¯à¤j©óµ¹©ó¤§­È(¥i¥H§¹¥þµ¥©óµ¹¤§­È) ¤]´N¬O 85.006%®É(¬O­n§ä¨ì85.006%)

ps. ¸Óªí¤º¤§©Ò¦³¸ê°T¬OÅܰʪº (¦]¬°¬°¨Ï±oÀÉ®×Åܤp) ¬G¥u¥H¿ï¾Ü³¡¤À¤§­È½Æ»s¨Ã¶K©óªÅ¥Õ¸Õºâªí

§Ú¬O¨Ï¥Î IF(A>B,C,A)

A=³Ì±µªñ¤§­È(²Ö­pµo¥Í²v)=MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),D3:D1026))

B=¿é¤J¤§­È=O6

¸Ó¹ïÀ³¤§µo¥Í²v=MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),C3:C1026))

C=³Ì±µªñ¤§­È-¸Ó¹ïÀ³¤§µo¥Í²v=MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),D3:D1026))-MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),C3:C1026))

¬GP6Åܦ¨«Üªø
{=IF(MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),D3:D1026))>O6,MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),D3:D1026))-MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),C3:C1026)),MIN(IF(ABS(D3:D1026-O6)=MIN(ABS(D3:D1026-O6)),D3:D1026)))}

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

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

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

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




test2.zip (39.91 KB)

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

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

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD