Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Modify the formula from, say, =A1/A2 to =A1/$A$2 before copying it, so that the denominator will not change.

share|improve this answer
    
Thanks, you save me hours :) –  Benjamin Aug 12 '11 at 13:19
2  
Also, you can just fix the column using $A2 or just fix the row with A$2. This is useful when copying between different columns/rows (depending how your data is laid out) –  nico Aug 12 '11 at 13:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.