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

§ä´M±µªñ­È

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

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

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD