I have a calculation like this

```
=B8+((B2-1)*C8)
```

I want to multiple these calculation by just dragging it down. So I don't need to type the calculation for each row. The values `B8`

and `C8`

shall increase to `B9`

/ `C9`

, `B10`

/ `C10`

and so on. But I want to be `B2`

fixed (shall not increase).

Why?

`B2`

is just a variable in this calculation. So it's not okay to hard code this value into the calculation.

Is this possible? And yes: how?

I tagged this with google-docs and microsoft-excel since I don't care too much about which tool I'll use. But I'll prefer an answer for google docs.