When I drag down from D14 the multiplier also moves down a box which breaks the formula.
How do I drag down but keep the multiplier as J09?
Thanks.
Title edited (was “helpmeplease” and question retagged).
=SUM(D15+D15*J$09)
You should have a look at the difference between relative and absolute references: Addresses and References, Absolute and Relative.
To show the community your question has been answered, please tag the best answer (
), and/or vote for any helpful answer. Else, please edit your question to add information (answers are for solutions only).
Hello,
use absolute addressing for row 9 using $ prefix (=D15*(1+J$9), using function SUM() in this case is superfluous) and read
Ref.: LibreOffice Help - Addresses and References, Absolute and Relative
Hope that helps.