=A2/POWER(1+B2;C2)
Where in cells you can put numbers you like:
A2 is final amount (1 000 000)
B2 is rate (0,08)
C2 is number of months (120)
result is 97,5325 dolars per month.
=A2/POWER(1+B2;C2)
Where in cells you can put numbers you like:
A2 is final amount (1 000 000)
B2 is rate (0,08)
C2 is number of months (120)
result is 97,5325 dolars per month.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks