¦p¦ó³]©w·í¤Ñ«nªº¤é´ÁÅã¥Ü
- ©«¤l
- 107
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 138
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-5-2
- ³Ì«áµn¿ý
- 2024-11-27
|
¦p¦ó³]©w·í¤Ñ«nªº¤é´ÁÅã¥Ü
§Úªº»Ý¨D¬O ¦bA1Åã¥Ü ¦p¤U
=IF(TODAY()="8¤ë28¤é","¤j©n¥Í¤é","")&IF(TODAY()="9¤ë28¤é","¤G©n¥Í¤é","")&IF(TODAY()="10¤ë28¤é","¤T©n¥Í¤é","") |
|
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-27
|
=IFERROR(LOOKUP(1,0/(--TEXT(NOW(),"mdd")={828,928,1010}),{"¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"}),"")
°µÓ¹ï·Óªí, ¥Î²³æªºVLOOKUP |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-27
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 107
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 138
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-5-2
- ³Ì«áµn¿ý
- 2024-11-27
|
¥»©«³Ì«á¥Ñ lucky12345 ©ó 2020-8-28 10:49 ½s¿è
=IFERROR(LOOKUP(1,0/(--TEXT(NOW(),"mdd")={828,928,1010}),{"¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"}),"") ¤£¦æ ¶Ç¦^ #NAME?
.=IF(ISERROR(LOOKUP(1,0/(--TEXT(NOW(),"mdd")={828,928,1010}),{"¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"})),0,LOOKUP(1,0/(--TEXT(NOW(),"mdd")={828,928,1010}),{"¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"})) |
|
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-27
|
¦^´_ 4# lucky12345
¨S¦³iferror¥i¥Î???
=LOOKUP(,-FIND("|"&{"",828,928,1010}&"|",TEXT(NOW(),"||mdd|")),{"","¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"}) |
|
|
|
|
|
|
- ©«¤l
- 107
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 138
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-5-2
- ³Ì«áµn¿ý
- 2024-11-27
|
¦^´_ 5# ã´£³¡ªL
ÁÂÁ¯ê¤j¥i¥H¤F |
|
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤
|
|
|
|
|