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

¦p¦ó³]©w·í¤Ñ­«­nªº¤é´ÁÅã¥Ü

¦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°ê¤¤

=IFERROR(LOOKUP(1,0/(--TEXT(NOW(),"mdd")={828,928,1010}),{"¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"}),"")

°µ­Ó¹ï·Óªí, ¥Î²³æªºVLOOKUP

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ 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°ê¤¤

TOP

¦^´_ 4# lucky12345


¨S¦³iferror¥i¥Î???
=LOOKUP(,-FIND("|"&{"",828,928,1010}&"|",TEXT(NOW(),"||mdd|")),{"","¤j©n¥Í¤é","±Ð®v¸`","Âù¤Q¸`"})

TOP

¦^´_ 5# ­ã´£³¡ªL

ÁÂÁ¯ê¤j¥i¥H¤F
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD