I have a calculation like this
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
C8 shall increase to
C10 and so on. But I want to be
B2 fixed (shall not increase).
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?