Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 19 Aug 2020 16:39:42 +0200Set a minimum amount for formulahttps://ask.libreoffice.org/en/question/261033/set-a-minimum-amount-for-formula/So, I have this small calc sheet. I have some set of values that decrease when I input my numbers on the right. One of these cells, likely inelegantly, takes values from two different cells, but one of them should never go below "0" when subtracting. I want that cell to know that even if it goes subzero, it should always display and have as its value no less than "0".
Thanks for the help! Wed, 19 Aug 2020 16:04:45 +0200https://ask.libreoffice.org/en/question/261033/set-a-minimum-amount-for-formula/Answer by erAck for <p>So, I have this small calc sheet. I have some set of values that decrease when I input my numbers on the right. One of these cells, likely inelegantly, takes values from two different cells, but one of them should never go below "0" when subtracting. I want that cell to know that even if it goes subzero, it should always display and have as its value no less than "0". </p>
<p>Thanks for the help! </p>
https://ask.libreoffice.org/en/question/261033/set-a-minimum-amount-for-formula/?answer=261037#post-id-261037Use `MAX(A1;0)` in the calculation for that cell if it is A1, for example.Wed, 19 Aug 2020 16:39:42 +0200https://ask.libreoffice.org/en/question/261033/set-a-minimum-amount-for-formula/?answer=261037#post-id-261037