
ã¡ã«ã«ãªãã©ãã®å©çèšç®ãã¹ãã¬ããã·ãŒãã§ïœä»å ¥ãäžéã®åŒ
10/3ã«ç§ãã¡ãå ¬éããèšäºã§ããã£ãã¡ãŒã« ãã©ã€ãã³ã®ä»å ¥ãäžéã1,872åãšæžããŸãããæ¢±å è³æãšæ¯èŸŒææ°æãåŒãç®ã«å ¥ããŠããªãã£ãã®ã§ãå ¥ããŠåºãçŽããš1,722åã150åãçãæ°åã§ããïŒæ¢±å è³æ100åãšæ¯èŸŒææ°æ50åã¯ä»®ã®æ°åã§ãïŒã
èšç®ã®æãã¯ã売ããããšã«ããæ°ã¥ããªãããšããããŸããè²·ã£ãããšã§èšç®ããŠããæã£ãä»å ¥ãå€ã¯æ»ããŸãããããã§ãä»å ¥ããåã®äžéãåºã衚ãããšã¯ã»ã«ã§äœããŸããããã®èšäºã§ã¯ããã®åŒããExcel ã§ã Google ã¹ãã¬ããã·ãŒãã§ã䜿ãã颿°ïŒROUNDã»ROUNDUPã»IFã»ORïŒã ãã§çµãã§ããã®ãŸãŸè²Œãã圢ã§èŒããŸãã
èªã¿çµãããšã次ã®3ã€ãåºã衚ãèªåã§äœããŸãã
ä»å ¥ãã®äžé
æ³å®å©çãšãäžé以å ãã®å€å®
èµ€åã«ãªããªãæäœå£²å€
å ã«æ±ºããŠããæ°å
衚ã«å ¥ããæ°åã¯ã次ã®ãšããã§ããäŸã§ã¯ãç§ãã¡ã10/3ã«èª¿ã¹ãããã£ãã¡ãŒã« ãã©ã€ãã³ãã®å£²ãåãã®äžå€®å€ã3,580åã§å£²ãããã®ãšããŸãã
売ãã倿®µïŒ3,580å
è²©å£²ææ°æçïŒ10%ïŒååã売ããŠååŒãå®äºãããšãè²©å£²äŸ¡æ ŒããåŒãããŸããå ¬åŒãã«ãã§2026-10-07ã«ç¢ºèªïŒ
éæïŒ850åïŒããããã¡ã«ã«ãªäŸ¿ã®å® æ¥äŸ¿ã80ãµã€ãºãå ¬åŒã®éæè¡šïŒ
梱å è³æïŒ100åïŒä»®ã®æ°åïŒ
æ¯èŸŒææ°æïŒ1ä»¶ããã50åïŒä»®ã®æ°åã1å200åã®æ¯èŸŒã4ä»¶ã§ãŸãšããå ŽåïŒ
æ®ãããå©çïŒ500å
å®éã®ä»å ¥ãå€ïŒ1,872åïŒ10/3ã®èšäºã®ã梱å è³æãšæ¯èŸŒææ°æãå ¥ããã«åºããäžéãããã®ãŸãŸä»å ¥ãå€ã«ãããšä»®å®ããæ°åïŒ
梱å è³æãšæ¯èŸŒææ°æã¯ã人ã«ãã£ãŠéãã®ã§ä»®ã«çœ®ããŠããŸããèªåã®æ°åã«å€ããŠäœ¿ã£ãŠãã ããã
1ä»¶ã ãèšç®ãã衚ãäœã
æ°ããã·ãŒããéããŠãAåã«é ç®ãBåã«æ°åãå ¥ããŸããB2 ã¯ã10% ã 0.1 ã§å ¥ããŸãã
B1ïŒå£²ãã倿®µïŒ3580ïŒ
B2ïŒè²©å£²ææ°æçïŒ0.1ïŒ
B3ïŒéæïŒ850ïŒ
B4ïŒæ¢±å è³æïŒ100ïŒ
B5ïŒæ¯èŸŒææ°æ(1ä»¶ããã)ïŒ50ïŒ
B6ïŒæ®ãããå©çïŒ500ïŒ
B7ïŒå®éã®ä»å ¥ãå€ïŒ1872ïŒ
次ã«ãB9ãB14 ã«åŒã1æ¬ãã€è²ŒããŸããAåã®èŠåºãã¯ã奜ããªèšèã§æ§ããŸããã
B9ïŒè²©å£²ææ°æ
B10ïŒä»å ¥ãã®äžé
B11ïŒæ³å®å©ç
B12ïŒå©çç
B13ïŒå€å®
B14ïŒèµ€åã«ãªããªãæäœå£²å€
åŒã¯ãäžã®é ã«äžŠãã§ããŸããã»ã«ã¯ã1ã€ãã€éžãã§è²ŒããŸãã
=ROUND(B1*B2,0)
=B1-B9-B3-B4-B5-B6
=B1-B9-B3-B4-B5-B7
=B11/B1
=IF(B7<=B10,"OKïŒäžé以å
ïŒ","äžéè¶
ã")
=ROUNDUP((B7+B3+B4+B5)/(1-B2),0)B12 ã¯ãæžåŒããããŒã»ã³ããŒãžãã«ããŸããããã§ã®å©ççã¯ãæ³å®å©çã売ãã倿®µã§å²ã£ããã®ã§ãã
çµæã®èŠæ¹
äžã®æ°åãå ¥ãããšã次ã®å€ãåºãŸãã
è²©å£²ææ°æïŒ358å
ä»å ¥ãã®äžéïŒ1,722å
æ³å®å©çïŒ350å
å©ççïŒçŽ9.8%
å€å®ïŒäžéè¶ ã
èµ€åã«ãªããªãæäœå£²å€ïŒ3,192å
æ®ãããå©çã¯500åã§ããã1,872åã§ä»å ¥ãããšãäžéã®1,722åã150åè¶ ããŠãæ³å®å©çã¯350åã«ãªããŸãããã®150åã¯ãç§ãã¡ã10/3ã®èšäºã§ã梱å è³æãšæ¯èŸŒææ°æãå ¥ããã«åºããäžéãšãå ¥ããŠåºãçŽããäžéã®å·®ã§ãã
æäœå£²å€ã®3,192åã¯ãå©çã0å以äžã«ãªãç®å®ã§ããææ°æãåæšäºå ¥ãããããåŒã®äžã§ã¯1åã®äœè£ãåºãŸããæ®ãããå©çã¯å«ãã§ããŸãããå£²ãæ®ã£ãŠå€äžããããšãã®ç®å®ã«ããŸãã
äœä»¶ã䞊ã¹ã衚ã«ãã
åè£ãæ¯ã¹ããªãã1è¡ã«1ã€ã®åè£ã眮ããŸãã1ã2è¡ç®ã«èšå®ã4è¡ç®ã«èŠåºããæžããŸãã
A1ïŒè²©å£²ææ°æçãB1ïŒ0.1
A2ïŒæ¯èŸŒææ°æã®æåãB2ïŒ50
4è¡ç®ã®èŠåºãã¯ãAåããé ã«ã次ã®ãšããã§ãã
AïŒååã¡ã¢
BïŒå£²ãã倿®µ
CïŒéæ
DïŒæ¢±å è³æ
EïŒæ®ãããå©ç
FïŒå®éã®ä»å ¥ãå€
GïŒè²©å£²ææ°æ
HïŒä»å ¥ãã®äžé
IïŒæ³å®å©ç
JïŒå€å®
KïŒèµ€åã«ãªããªãæäœå£²å€
BãF ã«æ°åãå ¥ãã5è¡ç®ã® GãK ã«ã次ã®åŒããäžããé ã«1æ¬ãã€è²ŒããŸãã
=IF(B5="","",ROUND(B5*$B$1,0))
=IF(B5="","",B5-G5-C5-D5-$B$2-E5)
=IF(OR(B5="",F5=""),"",B5-G5-C5-D5-$B$2-F5)
=IF(OR(B5="",F5=""),"",IF(F5<=H5,"OKïŒäžé以å
ïŒ","äžéè¶
ã"))
=IF(OR(B5="",F5=""),"",ROUNDUP((F5+C5+D5+$B$2)/(1-$B$1),0))åŒã¯æšªã«äžŠã¶ã®ã§ã1è¡ãã€ã³ããŒããŠãG5 ãã K5 ãŸã§1ã€ãã€è²ŒããŸãã貌ãçµãããã5è¡ç®ã® GãK ãéžãã§ãäžãžã³ããŒããŸãã6è¡ç®ä»¥éããåãåŒãèªåã®è¡ãèŠãŠåããŸãã
ä»å ¥ãå€ãå ¥ããã«å£²ãã倿®µã ãå ¥ãããšãä»å ¥ãã®äžéã ããåºãŸããä»å ¥ããåã«äœ¿ãã®ã¯ããã®åœ¢ã§ãããã ããéæã»æ¢±å è³æã»æ®ãããå©çã空æ¬ã ãšã0åãšããŠèšç®ãããŠãäžéãé«ãåºãŸããäžéã䜿ããšãã¯ãCãE ãåããŠãã ããã
ã€ãŸããããã4ã€
1. ææ°æçãåŒã«çŽæ¥æžããªãã *0.1 ãšæžããšãææ°æçãå€ãã£ããšãã«ãå šéšã®åŒãçŽãããšã«ãªããŸããB1 ã«çœ®ããŠããã°ã1ãæã§æžã¿ãŸãã
2. $ ãä»ããã $B$1 ã® $ ã¯ãã³ããŒããŠãåç §å ãåãããªãå°ã§ããä»ãå¿ãããšãäžã®è¡ã§ B2ãB3 ãèŠã«ãã£ãŠãæ°åããããŸãã
3. 空æ¬ã®è¡ã¯ãåŒã IF(B5="","",...) ã§å ãã å ãŸãªããšãäœãå ¥ããŠããªãè¡ã« 0 ãè² ã®æ°ãåºãŠãèŠã¥ãããªããŸãã
4. 端æ°ã ææ°æã®ç«¯æ°ã¯ãROUND ã§åæšäºå ¥ããŠããŸããå®éã®ç«¯æ°ã®æ±ãã¯ç¢ºèªããŠããªãã®ã§ã1åãããããšããããŸããæäœå£²å€ã¯ ROUNDUP ã§åãäžããŠãè¶³ããªãåŽã«å¯ããªãããã«ããŠããŸãã
確èªã§ããŠããªãããš
åŒã¯ãèšç®ã©ã€ãã©ãªã§æ€ç®ããŸãããExcel ãš Google ã¹ãã¬ããã·ãŒãã®ç»é¢ã§ããã®èšäºã®åŒã1æ¬ãã€æã£ãŠç¢ºãããããã§ã¯ãããŸãããã³ããŒããŠçµæãåããªããšãã¯ãå šè§ã®èšå·ããB ãš 1 ã®éã®ç©ºçœãæ··ãã£ãŠããªããèŠãŠãã ãã
å ¬åŒã®æéã¯ã2026-10-07 ã«ç¢ºèªããéé¡ã§ããå€ããããšãããã®ã§ã䜿ãåã«å ¬åŒããŒãžã§ç¢ºèªããŠãã ãã
äŸã¯ã売ãã倿®µã3,580åã ã£ããšãããã®ã§ãããã®å€æ®µã§å£²ããä¿èšŒã§ã¯ãããŸãã
ããããã¡ã«ã«ãªäŸ¿ãªã©ãã»ãã®é éæ¹æ³ã®éæã¯ç¢ºèªããŠããŸãã
å©çã¯ä¿èšŒã§ããŸãã
èªåã§äœãã®ã倧å€ãªã
ãããŸã§ã®åŒã§ã衚ã¯äœããŸããäœãã人ã«ã次ã®ã·ãŒãã¯èŠããŸããã
åãåŒã䜿ã£ãŠãç§ãã¡ãäœã£ãã·ãŒãããããŸããåè£ã30è¡ãŸã§äžŠã¹ãããŸãã売ãåãã®å€æ®µ15ä»¶ããçãäžã®å€æ®µãåºãã·ãŒããè²åããèšå ¥äŸãæéã¡ã¢ãã€ããŠããŸãã500åã§ãã