Help with excel savings spreadsheet

Newme2014

Hi, not sure if this is possible or worth the hassle but I'm trying to do a spreadsheet that shows starting balance then daily incomings and outgoings with the daily interest added.
I've got column A with dates, column B with income, C with outgoings and then D would show the running total. I've tried things like =2000+0.0082% but it doesn't do anything, I'm not very good with this stuff though so any help appreciated, even if it's to say I'm totally wasting my time and it's a pointless idea

Thanks

talexuser

try =2000+2000*0.0082%
should come out as 2000.16 (at 2 decimal places)

colsten

Newme2014 wrote: »

I've tried things like =2000+0.0082% but it doesn't do anything

You need to tell Excel what the percentage is of.

If you want to calculate 0.0082% of 2000: =2000*0.0082%

If you want to add the result of that calc to 2000 in the same cell, you need to say =2000+(2000*0.0082%)

More info on the Help button in your Excel :cool:

Newme2014

Ah ha! I knew I was missing the bit about what the percentage was of but had NO idea how to do it. Thanks for the help, will give it a try later.

AlwaysLearnin

colsten wrote: »

If you want to add the result of that calc to 2000 in the same cell, you need to say =2000+(2000*0.0082%)

Or 2000 * 1.0082%?

talexuser

AlwaysLearnin wrote: »

Or 2000 * 1.0082%?

'fraid not. It would have to be =2000*1.000082 to achieve the % which is valid but maybe a little more difficult to remember.

AlwaysLearnin

My bad. That'll teach me to read/respond half heartedly on a train after a couple of drinks...:o

bigfreddiel

talexuser wrote: »

try =2000+2000*0.0082%
should come out as 2000.16 (at 2 decimal places)

????0.0082% is 0.000082, so small it's almost zero so not worth worrying about.

It looks like they don't teach basic arithmetic anymore!

Cheers fj

noggin1980

bigfreddiel wrote: »

????0.0082% is 0.000082, so small it's almost zero so not worth worrying about.

It looks like they don't teach basic arithmetic anymore!

Cheers fj

Which is an interest rate of around 3% totally worth worrying about, if you are going to be rude at least be right first.

Newme2014

Yup, it's 3% a year and my balance will be varying from £4,000 to £10,000 over the next few months so I'm a little obsessed with working out roughly how much I'll be getting back

Eco_Miser

You don't want to add the interest to the running total daily, just at the end of the month. So cell En (n standing for the row number) would hold =Dn*0.0082%, and in column F, on the last day of the interest period, sum all of column D for the month, and add that to the running balance.