Excel..interest formula
Author
Discussion

silverfoxcc

Original Poster:

8,478 posts

176 months

Sunday 25th November 2018
quotequote all
want to do a spreadsheet as follows

row
1 col A col b col c
2 2019 60 300
3 2020
4 2021
etc

For 2020 b3 is to be (b2 plus 5%) c3 to be (b3 +c2)
for 2021 b4 is to be (b3 plus 5%) c4 to be (b4+c3)
etc
etc
etc


I have tried in b3 = b2/100*105 and in c3 =(b3+c2) .When i try to drag is down so i dont have to type in the formula in each box it just stays as the b3 and C3 boxes

What and how do i click on the c3 box to get this please?

MOBB

4,595 posts

158 months

Sunday 25th November 2018
quotequote all
Not sure I understand 100% but try putting dollar signs in the cell ref

Eg A1 try $A$1

The dollar locks the ref when you drag down

Or maybe I’ve misunderstood?


ninja-lewis

5,507 posts

221 months

Sunday 25th November 2018
quotequote all
Check the calculation settings for the file - sounds like it's not on automatic.

https://support.office.com/en-us/article/change-fo...

silverfoxcc

Original Poster:

8,478 posts

176 months

Sunday 25th November 2018
quotequote all
Light bulb moment

Held and dragged bootom RH corner and result!!


Case closed#