Numbers on my iPad Pro is giving incorrect calculations

Question

VCOL23 Author

Level 1

4 points

Numbers on my iPad Pro is giving incorrect calculations

Im simply trying to calculate the cost of an item.

Column F2= £0.01

Column I2= £15

On the calculator the answer i get by multiplying both is £0.15

However, when working out in numbers using formula =sum(I2xF2) the answer i get is £0.09.

I've also tried simply typing =I2xF2 and again get the same answer of £0.09

I've changed the data format in both rows to show as currency. Still no joy

[Re-Titled by Moderator]

Original Title: Numbers on ipad pro, providing incorrect calculation

Posted on Aug 30, 2025 05:21 AM

Reply

Answer 1

Badunit

Level 7

29,844 points

Aug 30, 2025 06:02 AM in response to VCOL23

It appears that one (or both) of those numbers is not the exact number you see in the cell, but is rounded up. You may have F2 formatted to 2 decimal places causing the number to be rounded up for display in the cell but the underlying value in the cell (which it uses for the calculation) is not rounded up.

0.006 will round to 0.01 for display in the cell

0.006 x 15 = .09

You also may have formatted the result cell to 2 decimal places and it is not exactly 0.09 either.

If the "0.01" is the result of a formula, you can put ROUND around it to actually round it to 2 decimals.

=ROUND(your_formula,2)

Reply