Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 03 Jul 2019 11:21:01 +0200How to use Greater Than and Less Than to Prevent or Allow Equationshttps://ask.libreoffice.org/en/question/199814/how-to-use-greater-than-and-less-than-to-prevent-or-allow-equations/I'll do my best to explain what I mean.
=IF(H3**>**H4,H3-H4) This formula works as intended and lets me easily subtract the values in H3 and H4.
The issue is if I add, IF(H3**<**H4,H3-H4) I still need the values to subtract, but I don't want the values to go below 5 or into the negatives.
So I'm not sure how to set a minimum, I assume it is MIN(), but then I'm not certain on how to set up multiple functions together since my previous attempts to do so didn't work too well. CSTIGWed, 03 Jul 2019 11:21:01 +0200https://ask.libreoffice.org/en/question/199814/Incorrect results produced by simple subtractionhttps://ask.libreoffice.org/en/question/109372/incorrect-results-produced-by-simple-subtraction/To reproduce:
In cell A1 enter the value 65941.152
In cell B1 enter the formula A1-65536
The value displayed in cell B1 will be 405.152000000002
Libre Office 5.3.1.2 Linux 4.9.18 64bit
CC2099Fri, 07 Jul 2017 21:16:32 +0200https://ask.libreoffice.org/en/question/109372/In Writer, in a table, is it possible to subtract one cell from another cell?https://ask.libreoffice.org/en/question/87862/in-writer-in-a-table-is-it-possible-to-subtract-one-cell-from-another-cell/When I use this formula, =<B7>-<B8>, I get the wrong answer. If B7=100 and B8=40, the answer should be 60, but the result I get is -40. Is this possible, and if so, what's the syntax? Thanks!alohaboyFri, 17 Feb 2017 04:11:35 +0100https://ask.libreoffice.org/en/question/87862/Why does subtracting a time from a cell return Err:502?https://ask.libreoffice.org/en/question/38284/why-does-subtracting-a-time-from-a-cell-return-err502/Given cell Q123 is formatted to display a time as 13:37 entering `=Q123-2:30` in another cell results in `Err:502`. Why?abiWed, 13 Aug 2014 19:11:35 +0200https://ask.libreoffice.org/en/question/38284/How to obtain the difference (subtract) decimal values in a field in two records in a table and enter this into another table?https://ask.libreoffice.org/en/question/31043/how-to-obtain-the-difference-subtract-decimal-values-in-a-field-in-two-records-in-a-table-and-enter-this-into-another-table/Working in Librebase, Windows 7, 32 bit. We record KWH meter reading for a number of meters at monthly intervals. We need to obtain the difference between two subsequent readings for each meter and record the figure in another table. The table records meter identity (int), reading date, record identity (primary key). Short of re-entering previous/last reading also, how can we do this in librebase? Something like Dlookup() function in Access?
Further clarification: I record serially readings from (say) 50 meters each month. Each meter is uniquely identified (through a separate table, foreign key) and each reading has a unique id (primary key), of course the date is recorded too. After entering the data for a month, I need to know (and record in a separate table) each meters consumption. I can obviously sort or filter data by meter identity plus order of reads (and the dates), but there will be gaps (and not necessarily of a fixed number).
Years ago (mid nineties) I worked with dBase 4 & 5 where the data was read into memory variables, skip 1 or skip -1 used to move between rows and a small function used to return the sum or difference which could be recorded in another table if required. Life was simpler! PChitnisTue, 11 Mar 2014 09:45:09 +0100https://ask.libreoffice.org/en/question/31043/calc formula/ code helphttps://ask.libreoffice.org/en/question/28599/calc-formula-code-help/Hi I am writing this for a family member, I have also added a image to help me.
He wants data 2 to be subtracted from data 1 and shown the answer in the next row of data 2.
he will be adding to this sheet every month so I'm after a code that will repeat the said formula.
![image description](http://www.radiosean.co.uk/calc.png)
Sorry if I have not expand myself feel free to ask any follow up questions RadioSeanUKMon, 20 Jan 2014 23:27:04 +0100https://ask.libreoffice.org/en/question/28599/