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

½Ð°Ý°ª¤â«e½ú¡A¤½¦¡¦³¿ù»~ªº¦a¤è¶Ü¡H

½Ð°Ý°ª¤â«e½ú¡A¤½¦¡¦³¿ù»~ªº¦a¤è¶Ü¡H

½Ð°Ý¦U¦ì°ª¤â«e½ú¡A§Ú¦bDÄæ¼g³o¤½¦¡¦³¿ù»~ªº¦a¤è¶Ü¡H
=IF(OR(A1>B1, A1<C1),"1","-1")
§Ú·Q¼gªº¤½¦¡¬O ---¦pªG 200 ¡]AÄæ¡^¤j©ó300¡]BÄæ¡^·|¦bD1Äæ¥X²{ 1  ©Î ¤p©ó100¡]CÄæ¡^·|¦bD1Äæ¥X²{ -1

If(A1>B1,"1",IF(A1<C1,"-1",""))

TOP

¦^´_ 2# kim223824
ÁÂÁÂK¤j

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD