Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 24 Aug 2017 21:22:33 +0200Calculate the difference between two cellshttps://ask.libreoffice.org/en/question/126545/calculate-the-difference-between-two-cells/ In cell 1A value = 100
in cell 2A value = 200
In cell 3A value = 300
..and so on
Difference amount goes into 1B
So in this case 1B = 200 (3A-1A)
Without knowing how many entries will be introduced in column A (could be 10 or could be 110 entries)
How can I ask calc to calculate the difference between the last entry in Column A and the first Entry in Column A (1A)
So Basically I just want to subtract the first entry from the last current entry In Column A with out out knowing how many entries there might be.
Thanks for the helpsimontfsThu, 24 Aug 2017 21:22:33 +0200https://ask.libreoffice.org/en/question/126545/