1 question that will take 1 minute of your time - Excel simple formula

Ivonne

New Member
Joined
Sep 10, 2014
Messages
2
Hello everyone,
I like to use Excel to calculate this and would like formula for each field:

Initial deposit is $100
That $100 makes 3% per day = $103 in 1 day
Then if I enter 2 days I will start to compound interest and will make total 106.09 and so on.

Able to change values:
A1-deposit amount
B1-interest per day (0-20%)
C1-number of days compounded interest
D1-I will get Total

Example:
Initial deposit is $100
That $100 makes 3% per day = $103 in 1 day
Then if I enter 2 days it will start to compound interest and will make total 106.09 and so on.

Can you help? I am total newbie and need little jump start ;)
(I promise I will learn)

Thank you in advance,
Ivonne
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

lyanik

Board Regular
Joined
Mar 11, 2014
Messages
67
After one day, the $100 sees 3% growth (103% of original) and after two days it sees 6.09% growth (106v09% of original). If you'll notice, 1.0609 is 1.03^2. The next day would see 1.03^3 = 1.092727 → 9.2727% growth.

So the formula would simply be (if your value in B1 is just a number between zero and twenty, i.e. just 3 instead of 0.03 or 3%):

=A1 * (1 + B1/100) ^ C1
 

Ivonne

New Member
Joined
Sep 10, 2014
Messages
2
Wow, I made it - thanks to YOU.

Thank you so much......

BTW: would you happen to know of any application like Excel that I can use on the website. Just asking, probably better if I post new message on the forum?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,017
Messages
5,834,959
Members
430,330
Latest member
drAli77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top