CALCULATE MONTHLY DECREMENTS IN EXCEL

I used excel to list the formula for you this afternoon and told me to send it to you by email.

The first method is the second method.

Repayment Month Decreasing Monthly Repayment Monthly Repayment Month Monthly Repayment Amount.

January 2000 January 2000

February 12, 1988 February 1988

March 12, 1976 March 1976

April 12 1964 April 1964

May 12 1952 May 1952

June 12 1940 June 1940

July 12 1928 July 1928

August 12, 1916 August 1916

September 12 1904 September 1904

October 12 1892 October 1892 November 12 1880 November 1880 December 12 1868 December 1868 December 12 1856 December 1856 December 1856 December 12 1844 December 1844 December 1844 December 12 1832 December 1832 December 1820 December 1820 December 1808 December 1808 December 1808 December 1808 December 18 18 1896 December 18 1796 19 12 1784 19 1784 20 12 1772 20 1772 21 12 1760 21 1760 22 1760 12 1748 22 1748 23 12 1736 23 1736 24 12 1724 24 1724 12 1712 1712 1712 1712 1700 1700 1700 1700 1700 1700 1700 1700 1736 1736 1736 1736 1724 1724 1724 1724 1724 1724 1712 1712 1712 1712 1712 1712 1700 1700 1700 1700 1700 1700 1748 27 12 1688 27 month 1688 - 28 12 1676 28 1676 - 29 12 1664 - 29 1664 - 30 12 1652 - 30 1652 - 31 12 1640 - 31 1640 - 32 12 1628 - 32 1628 - 33 12 1616 - 33 1616 - 34 12 1604 - 34 1604 - 35 12 1592 - 35 1592 - 36 12 1580 - 36 1580 1580 - 36 1580

A formula pulls out of it.。。

The result is good, but where to put the result, how to display, explain the good to give the result.

Kiss <>

A month-to-month decrease is one that decreases with a certain regularity. In mathematics, monotonic decreasing means that the derivative of a function is less than 0, which is manifested in the graph as the value of the function (the strain variable) decreases as the independent variable increases. i.e. f(x+t)-f(x)0).

Derivative, also known as derivative value. Also known as micro-quotient, it is an important basic concept in calculus. When the independent variable x of the function y=f(x) produces an increment δx at a point x0, the ratio of the increment δy of the output value of the function to the increment δx of the independent variable is at the limit of δx when δx approaches 0 or the rotten base limit a If the calendar ruler exists, a is the derivative at x0 and is denoted as f'(x0) or df(x0) dx.

a2 writes the formula:

a1*drop-down, example:

=a1*(1-2%), a2 puts a formula, and then pulls it down, and it will inherit the formula and decrement.

Enter 10000 in B1 and =5%% in cell C1 (or Alternatively: or Formula: in B2

b$1-$b$1*(1-$c$1) row($a 1) copy and pull down, that is, the amount of money you have accumulated on the first day.

Finally, start typing in cell A2: 1 day, copy and pull down, you can get the number of days and the money corresponding to column b on the right.

If the daily income is to be subtracted from the 12% fee, the formula for cell B2 is changed to:

$b$1-$b$1*(1-$c$1)^row($a1))*1-12%)

Copy and pull down, you can do it, everything else remains the same.

10000-10000*5%%=10000*（1-5%%）

After n days, it is 10,000*(1-5%%) to the nth power.