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

·í¨â­ÓÄæ¦ì³£¨S¦³­È,¥X²{ªÅ¥Õ

·í¨â­ÓÄæ¦ì³£¨S¦³­È,¥X²{ªÅ¥Õ

¤U¦C¬O§Úªº¨ç¼Æ
=IF(OR(Z2="",AE2=""),"¹O´Á",IF(Z2-AE2=0,"",""))

§Ú·Q­nªº»Ý¨D¦p¤U:
Z2Ä榳­È,AE2Ä榳­È,«hÅã¥Ü=>ªÅ¥Õ
Z2Ä榳­È,AE2Äæ¨S¦³­È,«hÅã¥Ü=>¹O´Á
Z2Äæ¨S¦³­È,AE2Äæ¨S¦³­È,«hÅã¥Ü=>³B²z¤¤

½Ð°Ý§Úªº¨ç¼Æ­þ¸Ì»Ý­n¦A­×¥¿©O?
ÁÂÁÂ

¦^´_ 1# milk609609

   
=IF(AND(Z2<>"",AE2<>""),"",IF(AND(Z2<>"",AE2=""),"¹O´Á",IF(AND(Z2="",AE2=""),"³B²z¤¤","")))

TOP

¦^´_ 2# ABK


    ÁÂÁÂABK¦Ñ®v

TOP

´£¨Ñ¥t¤@­Ó¤è¦¡
=IF(ISBLANK(Z2),IF(ISBLANK(AE2),"³B²z¤¤",""),IF(ISBLANK(AE2),"¹O´Á",""))
test.png

©êºp¡A¹Ï¤¤ªºFALSE©MTRUE ¬O§Ñ¤F§R¡A¨S·N¸q

TOP

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