Go Premium for a chance to win a PS4. Enter to Win

x
Solved

Posted on 2015-01-15
Medium Priority
88 Views
Please see the attached Excel file, it is a very simple invoice file.
The total should be 281.69 obviously. But Excel gave the result of 281.68 which is incorrect obviously.
What is the problem??

Thanks!!
WrongGrandTotal.xls
0
Question by:techcity
• 3
• 2

LVL 27

Accepted Solution

Shaun Kline earned 1800 total points
ID: 40551975
You should add the round function on the PST and GST totals. If you increase the decimals to 3 digits, you will see the issue.
0

LVL 1

Author Comment

ID: 40551993
Thanks Shaun
How can I add "round" function? Can you please instruct me more details?
I do not know Excel much :-(
0

LVL 27

Assisted Solution

Shaun Kline earned 1800 total points
ID: 40552004
There are three round formulas (sorry, keep calling them functions) in Excel: Round(<your value>, # of decimals), RoundUp(<your value>, # of decimals) and RoundDown(<your value>, # of decimals).

The ROUND formula rounds to the nearest decimal.
The ROUNDUP formula always rounds your value UP. This own is good when calculating taxes, as you are.
The ROUNDDOWN formula always rounds your value DOWN.

Here's an example of ROUNDUP:
``````=ROUNDUP(A1*0.07, 2)
``````
0

LVL 1

Author Comment

ID: 40552031
Thanks. I will check this out.
0

LVL 84

Assisted Solution

David Johnson, CD, MVP earned 200 total points
ID: 40552654
Add 0.005 to both PST and GST (old programming trick)
=(D38*0.07)+0.005
WrongGrandTotal.xls
0

LVL 1

Author Closing Comment

ID: 40562637
Thank you!!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…