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

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

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

TOP

¦^´_ 4# lucky12345


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

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

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

TOP

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

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

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD