- ©«¤l
- 119
- ¥DÃD
- 39
- ºëµØ
- 0
- ¿n¤À
- 164
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-1
- ³Ì«áµn¿ý
- 2019-2-21
|
¦^´_ 13# p212
¤j¤j¯u¼F®` ¦pªG§Ú§ï¦¨³o¼Ë ¦³¿ìªk¯àÁYµu?
IF(($G2>LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ))*($M2="¤W¯Z"),"¿ð¨ì",IF((($G2<LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ)))*($M2="¤U¯Z"),"¦°h",""))),IF(($G2>LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ))*($M2="¤U¤È¤W¯Z"),"¿ð¨ì",IF((($G2<LOOKUP(,0/(MIN((¥»ªÀ-$G2)^2)=(¥»ªÀ-$G2)^2),¥»ªÀ)))*($M2="¤U¤È¤U¯Z"),"¦°h",""))
§Ú·Q»¡n¤W¯Z ¤U¯Z ¤À¦¨¤W¤È¤U¤È ¡A ·|¦³ª¬ªp¥u¦³¤U¤È¤W¯Z¤U¯Zªº¥X²{¡A ÁÙ¦³¦pªG¹J¨ì·í¤Ñ¥u¥X¶Ô¤W¤È¤W¯Z ¤§«á¤U¤È¤U¯Zªº ¦³¨ç¼Æ¥i¥H§PÂ_? |
|