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

­pºâ«ü©w®É¶¡¶¡¹j¤§¶}©l.¸`¼Æ³Ì°ª³Ì§C¼Æ­È

­pºâ«ü©w®É¶¡¶¡¹j¤§¶}©l.¸`¼Æ³Ì°ª³Ì§C¼Æ­È

¦baA.B.CÄæ¦ì¶ñ¤J®É¶¡.»ù®æ©M²Ö¿n¶q
­pºâ«ü©w®É¶¡(1¤ÀÄÁ.5¤ÀÄÁ.10¤ÀÄÁ.15¤ÀÄÁ.30¤ÀÄÁ.60¤ÀÄÁ)¶¡¹j¤§¶}©l.¸`¼Æ³Ì°ª³Ì§C¼Æ­È,¦p¹Ï00©M¹Ï02
­Y°Ï¸Ó®É¶¡¸ê®Æ´N¶ñ¤J0©ÎªÌ©µÄò¤W­Ó®É¶¡ÂIªºµ²§ô¼Æ­È(¦p¹Ï01©M¹Ï03)
¸ê®Æ®É¶¡·|¦³¸ó¶V24¤p®Éªº±¡§Î,¦p¹Ï04
¹Ï00.jpg
¹Ï01.jpg
¹Ï02.jpg
¹Ï03.jpg
¹Ï04.jpg

01.rar (17.29 KB)

02.rar (68.11 KB)

¦U¦ì¥ý¶i¦n
§Úªº·N«ä¬O»¡
¦baA.B.CÄæ¦ì¶ñ¤J®É¶¡.»ù®æ©M²Ö¿n¶q
µM«á´N¯à­pºâ±o¨ì....
1¤ÀÄÁ¶¡¶Z.5¤ÀÄÁ¶¡¶Z.10¤ÀÄÁ¶¡¶Z.15¤ÀÄÁ¶¡¶Z.30¤ÀÄÁ¶¡¶Z.60¤ÀÄÁ¶¡¶Z
ªº¶}©l¼Æ­È.µ²§ô¼Æ­È.³Ì°ª¼Æ­È.³Ì§C¼Æ­È

TOP

H3{=MAX((INT(A3:A10000*1440)=INT(F3*1440))*B3:B10000)

K3=LOOKUP(1,0/(A$2:A$2518<F3),C$2:C$2518)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522


    ©êºp
§Ú¬Ý¤£¤ÓÀ´:L

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD