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

[µo°Ý] ¦p¦ó§PÂ_·í¤ë¤é¼Æ¥[¥H­pºâª÷ÃB

[µo°Ý] ¦p¦ó§PÂ_·í¤ë¤é¼Æ¥[¥H­pºâª÷ÃB

ªì¦¸µo°Ý,½Ð±Ð¤@¤U,
§Ú²{¦b¦b°µ³Ò¤u¨C­Ó¤ëÁ~¤ô,
µM¦pªG¦³·s¶i/Â÷¾¤H­û¤¤³~³ø¨ì/Â÷¾,·|²o¯A¨ì³Ò«O¶Oªº­pºâ.
§Úªº°ÝÃD¦b©ó¤@¦~·í¤¤¦³¤À¤j¤p¤ë¤Î¶|¤ë,
§Ú­n¦p¦ó§Q¥Î¤½¦¡§PÂ_·í¤ë¤é¼Æ¬O§_µ¥©ó30¤é(³Ò«O­pºâ©T©w¥H30¤é­p)
¦p¤U¹Ï©Ò¥Ü:

°²³]1.³o­Ó¤ë¬°29¤é
²Ä¤@¦ì¬O10¤é¨ì¾,²Ä¤G¦ì¬O¥¿±`¤u§@.
§Ú¬O¥Î²³æªºround¤½¦¡°£¥H·í¤ë¤Ñ¼Æ¦A­¼¥H¥¼¨ì¾¤éªº¤Ñ¼Æºâ¥X,¦ý­Y¬O¤w¦b¾¥¿±`¤u§@ªº¤H´N¤£¾A¥Î³oºâªk¤F.
§Ú¤]¦³¸Õ¹L¥Îifªº¤è¦¡­pºâ,¦ý¦]§Ú¬O·s¤â,ÅÞ¿è¤W¦³ÂIÂण¹L¨Ó,¬G¦b¦¹½Ð±Ð¦U¦ì±M®aÀ°¦£.
¥ý¥H¹Ï¤ùÅã¥Ü,¦p¦³»Ý­n§Ú¶ÇÀɮתº¸Ü§Ú¦A¨Ó¶Ç.

·í¤ë¤Ñ¼Æ=DAY(EOMONTH(¤é´Á,0))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
·PÁ¦^´_,¦ý³o¦n¹³¥u¯à§PÂ_·í¤ë¤Ñ¼Æ,¨S¿ìªk¤ñ¹ï³Ò«O¥[«O¤é¼Æ«áºâ¥X¥¿½Tªºª÷ÃB
¤]´N¬O»¡°²³]³o­Ó¤ë¬O29¤é,
·s¤H¦b10¸¹³ø¨ì,¥»¤ëÀ³»âª÷ÃB=ROUND(D4/T1*(T1-X4),0)-->¦©°£¥¼³ø¨ì«eªº¤Ñ¼Æ
¦ý¹ï©ó¤w¸g¦b¤u§@ªº¤H¤ë¤ä=À³»â(¤]´N¬O¥¼³ø¨ì«e¤Ñ¼ÆE6=0),¦]¦¹¤W¦C¤½¦¡Åܦ¨¤£¾A¥Î¤F.
­n¦p¦ó§Q¥Î¨ç¼Æ¸Õºâ?
¤UªþÀɮ׬è³\¯àÀ°¤W¦£.
Question.zip (36.1 KB)

TOP

E4=IF(X4=30,,ROUND(D4/T$1*(T$1-X4),))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522
·PÁ±z,À°¤W¤j¦£¤F.
¤£ª¾¥i§_½Ð±Ð³o¨ç¼Æ¸Ìªº¨â­Ó³r¸¹¥Nªí·N«ä¬O?

TOP

¦^´_ 5# childking

IF(X4=30,0,ROUND(D4/T$1*(T$1-X4),0))-->0 ¬Ù±¼
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_  childking

IF(X4=30,0,ROUND(D4/T$1*(T$1-X4),0))-->0 ¬Ù±¼
hcm19522 µoªí©ó 2020-2-6 14:24

©Ò¥H³oÅÞ¿è·N«ä¬O...­YX4=30,«h¦^¶Ç0,§_«h¨ÌROUND(D4/T$1*(T$1-X4)¸Õºâ,§Ú³o¼ËªºÅÞ¿è¹ï¶Ü?

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD