CODEWITHSUNDEEP
excel-formula
Brandon Yarosz
Brandon Yarosz

Reputation: 17

Excel calculates wrong

I have a value (B3*40*52) where B3 == $16.09. If I calculate this value manually (16.09*40*52), my answer is $33,467.20. If I use the value B3 in a formula =B3*40*52, my answer is $33,476.35. The cells are formatted to Accounting. What gives?

I've tried using SUMPRODUCT(), ROUND(), SUMPRODUCT(ROUND()), SUM()...etc.

=SUM(B3*40*52), =SUMPRODUCT(B3*40*52), =ROUND(B3*40*52), =SUMPRODUCT(ROUND(B3*40*52))...

I expect $33,467.20, but instead, excel calculates $33,476.35. If the answer was within a few cents, it wouldn't be a big deal, but this is a $9 difference.excel formulas

Upvotes: 1

Views: 206

Answers (1)

Cornelius Sicker
Cornelius Sicker

Reputation: 160

The value in cell B3 might not be exactly 16.09. If you divide 33476.35 by 40*52 you get 16.094399... So if you set the cells to accounting with only two digits, Excel will round the display to 16.09. So actually Excel is right because it uses the full precision and your calculation just uses a rounded value.

Upvotes: 5

Related Questions