I am currently calculating percentages in LibreOffice Calc using the function =PART/TOTAL where PART and TOTAL are cell coordinates of a same column.Dragging-down the formula won't do, because the coordinate of the TOTAL cell will change along with the PART's.Ideally, I want to process this quickly, in a way that the coordinates of the PART changes while the TOTAL's would remain the same.How can I do that? Is there a function for this?
How to calculate percentages in LibreOffice Calc?
libreoffice
Modify the formula from, say, =A1/A2 to =A1/$A$2 before copying it, so that the denominator will not change.