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

EXCEL:¦p¦ó±N³o¨â­Ó¨ç¼Æ¦X¨Ö¦b¤@°_?

EXCEL:¦p¦ó±N³o¨â­Ó¨ç¼Æ¦X¨Ö¦b¤@°_?

=IF(H3=0,"",IF(Q3>=I3,"","¥¼§¹¦¨"))

=IF(AND(I3<>"",Q3<>""),"","")

½Ð°Ý¦p¦ó±N³o¨â­Ó¨ç¼Æ¨Ö¦b¤@°_,¤w¸Õ¹L¦n¦h¦¸
½Ð°ª¤â¸Ñµª,ÁÂÁÂ

½Ð°Ý¥i¥HÀ°À°¦£¶Ü?
=IF(H3=0,"",IF(Q3>=I3,"","¥¼§¹¦¨"))

=IF(AND(I3<>"",Q3<>""),"","")

½Ð°Ý¦p¦ó±N³o¨â­Ó¨ç¼Æ¨Ö¦b¤@°_,¤w¸Õ¹L¦n¦h¦¸
½Ð°ª¤â¸Ñµª,ÁÂÁÂ

TOP

¤w½Õ¾ã,À³¸Ó³o¼Ë¤~¹ï
=IF(Q3>=I3,"","¥¼§¹¦¨")

=IF(AND(I3<>"",Q3<>""),"","")

½Ð°Ý¦p¦ó,¦X¨Ö©O?

TOP

¤w½Õ¾ã,À³¸Ó³o¼Ë¤~¹ï
=IF(Q3>=I3,"","¥¼§¹¦¨")

=IF(AND(I3<>"",Q3<>""),"","")

½Ð°Ý¦p¦ó,¦X¨Ö©O?

TOP

¦^´_ 4# milk609609


    =IF(AND(I3<>"",Q3<>""),"","")¡A³o­Ó¨âªÌ±ø¥ó³£¹F¦¨«hÅã¥ÜªÅ¥Õ¡A§_¤]¬OªÅ¥Õ¡HÁÙ¬O"¥¼§¹¦¨"¡H
    ¬Ý¥H¤U¬O§_¬O§A»Ý¨Dªº...

    =IF(OR(Q3>=I3,AND(I3<>"",Q3<>"")),"","¥¼§¹¦¨")

    ³o¼Ëªº¸Ü¡A¥u¦³I3¦³­È¤~·|Åã¥Ü"¥¼§¹¦¨"¡AI3»PQ3¦³­Èªº¸Ü¡A¤£ºÞ«ç»ò¼Ë¥u·|Åã¥ÜªÅ¥Õ

    ¥i¥Hªº¸Ü¡A¸Ô²Ó´y­z...©ÎªÌ¤W¶Ç¹Ï¤ùµ¹¤j®a§a¡A·|¤ñ¸û¦nÀ°§A¸Ñµª

TOP

¦^´_ 3# milk609609


  §Ú²q
=IF(AND(I3="",Q3=""),"",IF(Q3>=I3,"","¥¼§¹¦¨"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD