ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD