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

§ä´M±µªñ­È

§ä´M±µªñ­È

¦U¦ì¦n¡G
°²³]¡G
(B1 = 21.2)
V1 = 25.6
V2 = 23.7
V3 = 24.6
½Ð±Ð¡A¦p¦ó¦b W1 ¤è®æÅã¥Ü³Ì±µªñB1¤§¼Æ­È¡A§YV2ªº23.7¡CÁÂÁ¡I

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2013-11-7 17:25 ½s¿è

=IF(B1>=(MAX(IF(V1:V3<= B1,V1:V3))+MIN(IF(V1:V3>=B1,V1:V3)))/2,MIN(IF(V1:V3>=B1,V1:V3)),MAX(IF(V1:V3<= B1,V1:V3)))
°}¦C¤½¦¡
§Ú¦b¥»½×¾Â¾Çªº
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

=LOOKUP(,0/(MIN((V1:V3-B1)^2)=(V1:V3-B1)^2),V1:V3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

²µu¦n¥Î..............ÁÂÁÂML089¤j ªº«ü¾É
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

{=INDEX(V1:V3,,MATCH(MIN(ABS((V1:V3-B1))), ABS(V1:V3-$B$1), 0))}

°}¦C¤½¦¡
ctrl+shift+enter
ss

TOP

«D±`ÁÂÁ¦U¦ì¸Ñµª¡A¥i¥H¥Î¤F¡C

TOP

=LOOKUP(,0/(MIN((V1:V3-B1)^2)=(V1:V3-B1)^2),V1:V3)
ML089 µoªí©ó 2013-11-7 18:09


¬Ý¤£ºØ¦¹¤½¦¡¥Nªíªº·N«ä¡A¥i¥HÀ°¦£¸ÑÄÀ¤@¤U¶Ü¡HÁÂÁÂ

TOP



µû¦ô­È¤½¦¡³v¨B¤F¸Ñ­pºâªºÅܤÆ

­«ÂI¡A
1. LOOKUP¹ï¿ù»~­È¥i¥H©¿²¤¤£¨ü¼vÅT
2. 0/(¤ñ¹ï°}¦C)¡A·í0/TRUE¬°0¡A0/FALSE¬°¿ù»~­È
3. LOOKUP(, ªí¥Ü lookup_value¨S¦³¶ñ­Èªí¬O¤º©w¬° 0
¨ä¥L¤½¦¡ªº»¡©ú«öF1´N¦³
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¼F®`¼F®`  §Ú¤S¦h¾Ç¨ì¤F  ·PÁ¦U¦ì¤j¤j

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD