- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-17 16:36 ½s¿è
¦^´_ 1# blueskyneter
Q1: §PÂ_¤@Ó¤é´Á¬O§_¦b¤@Ó½d³ò¤§¤º
=IF((A1>=DATEVALUE("2014/10/01"))*(A1<=DATEVALUE("2014/12/31")),"Yes","No")
¤W¦C¡u*¡v¥Nªí¡uAND¡v¤§·N
Q2:
1#¤§=IF(A2>"2014/11/14","¤j","¤p")
קאּ
=IF(A2>DATEVALUE("2014/11/14"),"¤j","¤p")
½Ð°Ñ¦Ò¡I |
|