Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 25 Feb 2018 19:09:13 +0100how do l divide 2430 dollars by 326 and make it equal 7.46https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/ doing spread sheet for my farm records and need to divide dollars by bushels to get average price when l use quotient feature it always give me whole number and when l round it gives me to many decimal points and won't let me convert to dollarsSun, 25 Feb 2018 18:09:02 +0100https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/Comment by librebel for <p>doing spread sheet for my farm records and need to divide dollars by bushels to get average price when l use quotient feature it always give me whole number and when l round it gives me to many decimal points and won't let me convert to dollars</p>
https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/?comment=147472#post-id-147472added the tag "calc"Sun, 25 Feb 2018 19:09:13 +0100https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/?comment=147472#post-id-147472Answer by Ratslinger for <p>doing spread sheet for my farm records and need to divide dollars by bushels to get average price when l use quotient feature it always give me whole number and when l round it gives me to many decimal points and won't let me convert to dollars</p>
https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/?answer=147471#post-id-147471Hello,
Quotient will only produce whole numbers so this is not wanted.
`ROUND` (from off-line help):
Syntax
ROUND(Number; Count)
Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.
This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.
Implementing this results in:
![image description](/upfiles/15195814793587434.png)
The result in C1 used the formula `=ROUNDUP(A1/B1,2)` to produce your desired result.
The result in C2 used the formula `=A1/B1`.
The result in C3 used the formula `=ROUND(2430/326,2)`
How you want the result to display is simply formatting the cell - right mouse click cell & select `Format Cells...`Sun, 25 Feb 2018 19:02:03 +0100https://ask.libreoffice.org/en/question/147463/how-do-l-divide-2430-dollars-by-326-and-make-it-equal-746/?answer=147471#post-id-147471