HI there,

I am trying to get a compound interest table going.

In the top, i have written down my contract details with the yearly payrate and compound interest rate.

At the bottom I have a list of the following years. Next to it, I would like to Autofill the Formula which calculates the amount that I need to pay in that year.

The Table looks like this:

```
H I
16 contract
17 payrate 23.00 €
18 ci 3.00%
19
20 2020 23.69 €
21 2021 24.40 €
22 2022 25.13 €
23 2023 25.89 €
24 2024 26.66 €
```

The Formula for cell is `I20: =I17+I17*I18`

. *(This must be typos, imo. Please edit to rectify. - Lupp)*

For cell I21 the formula is now based on the cell `I20: =I20+I20*I18`

.

For cell I22 the foormula is again now based on the previous cell `I21: =I21+I21*I18`

.

Once i mark the I20 and I21 cells and apply autofill (dragging the marked section down), the formula is messed up.

I would expect, that Libreoffice recognises, that the Cell I18 will stay constant in my formula. However Calc counts it up. So in the following Cells, the Cell I18, would be I19, I20, I21, etc.

How can I apply this simple formula to all the remaining cells without typing each one individually?