I’m trying to use a formula to calculate a monthly payment from a few values. For some reason, when I do the math using a calculator, I get the correct value (that has 9 digits of decimal place precision), but when running the formula in LibreOffice Calc or Google Drive, I get a rounded off number.

Here’s the formula:

=QUOTIENT(PRODUCT(E5,B5),POWER(SUM(B5,1),-120))

And here is an example of the values i’m using:

E5:$4619.47

B5: 0.0080208333

The answer that Calc/Google Drive outputs is $96.00, where the answer I’m looking for is $96.639 (Unsure as to whether I want 3 decimal places or not in the answer)

Anyone know how to remedy this? I’m trying to use this to present some figures, and am using quite a few references, so that column being rounded off isn’t acceptable.