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/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/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/