- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-20 15:37 ½s¿è
¦^´_ 6# keovin790916
1¡B¼W¥[»²§UÄæ¡u¥X¶Ô¼Ð·Ç¡vG2:G5
2¡BÀx¦s®æE2¿é¤J¤½¦¡
=IF($D2-LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)>0,"¿ð¨ì",IF($D2-LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)<0,"¦¨ì","·Ç®É"))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I
ª`¡G¤W¦C¤½¦¡¤§ LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)³¡¤À
°Ñ¦Ò http://forum.twbts.com/thread-10765-1-1.html ML089ª©¤j¸ÑÃD¤º®e |
|