Forum Discussion
Excel formula result doesn't match calculator result
Hi all,
New to the board but I did scour it (and other places) for an answer before posting this.
I have a pretty simple Excel formula but the result seems incorrect. I am creating a financial cover page for invoices that breaks out the tax from the net, displaying everything separately in a row.
It works fine but then I tested this amount: $340.70
I want to add 13% tax to that.
When I use a calculator: $340.70 * 1.13 = $385.00 (matches the amount on the invoice)
When I use excel: $340.70 * 1.13 = $384.99
When I use excel to isolate just the tax: $340.70 * 0.13 = $44.29 but when I use a calculator I get $44.30.
I can't figure out why Excel is shorting it by a penny.
6 Replies
The exact result of 340.70 * 1.13 is 384.991. Rounded to cents (2 decimal places), that is 384.99
The Windows calculator produces the same result:
- This is very strange indeed. The invoice itself has:
Base: $340.70
Tax: $44.30 (13%)
Total: $385.00
My desktop physical calculator duplicates this exactly.
I just tried the windows calculator and I get the same result you did, $384.991.
I also tried my iphone calculator and it gets $384.991.
Seems there is no excel issue then. It's just odd that the vendor and my physical calculator want $0.01 more. It must automatically round up if there is a thousandths of a penny. I've struggled with formatting for way too long for this result.. thanks for replying. Appreciated.I could understand if physical calculator shows 384.991 as 385.00. But why 44.291 is shown as 44.30 ? Perhaps special edition for the accountants, who made it?
By the way, you may enter in search bar in your browser (google.com, bing.com, etc) 340.7*1.13, it shows
One more option What is 13 percent of 340? Calculate 13% of 340. How much? (dollartimes.com)
In general tons of them.
