How do I round up QUOTIENT output?

[Quack]

For example, how would I get =QUOTIENT(20,11) to return 2 instead of 1? Or is there another function that would do this?

[anon73440385]

Hello,

you cant use function QUOTIENT() since according to LibreOffice Help - Quotient already returns an integer (cuts off the decimal places of the division) and not the result of the division. You need to divide numerator by denominator and round the decimal result. Hence use

=ROUND(20/11;0) --or–
=ROUNDUP(20/11;0)

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.