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:
And here is an example of the values i’m using:
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.