EXCEL:¦p¦ó±N³o¨âÓ¨ç¼Æ¦X¨Ö¦b¤@°_?
- ©«¤l
- 25
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- 64¦ì¤¸§@·~¨t²Î*64«¬³B²z¾¹
- ³nÅ骩¥»
- WINDOWS10®a¥Îª©
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-3-13
- ³Ì«áµn¿ý
- 2019-9-3
|
EXCEL:¦p¦ó±N³o¨âÓ¨ç¼Æ¦X¨Ö¦b¤@°_?
=IF(H3=0,"",IF(Q3>=I3,"","¥¼§¹¦¨"))
=IF(AND(I3<>"",Q3<>""),"","")
½Ð°Ý¦p¦ó±N³o¨âÓ¨ç¼Æ¨Ö¦b¤@°_,¤w¸Õ¹L¦n¦h¦¸
½Ð°ª¤â¸Ñµª,ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 25
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- 64¦ì¤¸§@·~¨t²Î*64«¬³B²z¾¹
- ³nÅ骩¥»
- WINDOWS10®a¥Îª©
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-3-13
- ³Ì«áµn¿ý
- 2019-9-3
|
½Ð°Ý¥i¥HÀ°À°¦£¶Ü?
=IF(H3=0,"",IF(Q3>=I3,"","¥¼§¹¦¨"))
=IF(AND(I3<>"",Q3<>""),"","")
½Ð°Ý¦p¦ó±N³o¨âÓ¨ç¼Æ¨Ö¦b¤@°_,¤w¸Õ¹L¦n¦h¦¸
½Ð°ª¤â¸Ñµª,ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 25
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- 64¦ì¤¸§@·~¨t²Î*64«¬³B²z¾¹
- ³nÅ骩¥»
- WINDOWS10®a¥Îª©
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-3-13
- ³Ì«áµn¿ý
- 2019-9-3
|
¤w½Õ¾ã,À³¸Ó³o¼Ë¤~¹ï
=IF(Q3>=I3,"","¥¼§¹¦¨")
=IF(AND(I3<>"",Q3<>""),"","")
½Ð°Ý¦p¦ó,¦X¨Ö©O? |
|
|
|
|
|
|
- ©«¤l
- 25
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- 64¦ì¤¸§@·~¨t²Î*64«¬³B²z¾¹
- ³nÅ骩¥»
- WINDOWS10®a¥Îª©
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-3-13
- ³Ì«áµn¿ý
- 2019-9-3
|
¤w½Õ¾ã,À³¸Ó³o¼Ë¤~¹ï
=IF(Q3>=I3,"","¥¼§¹¦¨")
=IF(AND(I3<>"",Q3<>""),"","")
½Ð°Ý¦p¦ó,¦X¨Ö©O? |
|
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 1
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-7-23
- ³Ì«áµn¿ý
- 2024-9-15
|
¦^´_ 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¸Ô²Ó´yz...©ÎªÌ¤W¶Ç¹Ï¤ùµ¹¤j®a§a¡A·|¤ñ¸û¦nÀ°§A¸Ñµª |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 3# milk609609
§Ú²q
=IF(AND(I3="",Q3=""),"",IF(Q3>=I3,"","¥¼§¹¦¨")) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|