EXCEL paid in installments, the unreasonable amount is smartly paid to the first payment -time with Excel: Nikkei Crostek Active

　This time is about debt repayment.Let's consider the case where you borrow 550,000 yen including interest and pay for 36 months with a monthly payment.

　In the figure below, B1 has a borrowed "$ 550,000" and "36" in the B2.The monthly repayment amount, B3, is "= B1/B2".As a result, "¥ 15,277.78 "returned.

　550,000 yen is not divisible with 36.In such a case, it is often the case that the unreasonable amount is paid together in the first time.Let's start over again with this concept.

　First, the B3, which is the monthly repayment amount, uses an int function to return an integer part that deletes the decimal point below.The int function is a function that cuts down the value below the decimal and returns only the integer.

　Returns the largest integer that does not exceed the specified number.

　数値　切り捨てて整数にする実数を指定する。

　Using this int function, the formula of B3 is set to "= int (B1/B2)".The result is "¥ 15,277.00 ".Since the decimal point is not required, press "Decimal display digit down" in the "Home" tab group in the "Home" tab to hide it.