Excel..interest formula
Discussion
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?
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?
Check the calculation settings for the file - sounds like it's not on automatic.
https://support.office.com/en-us/article/change-fo...
https://support.office.com/en-us/article/change-fo...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


