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
LVL 1
###### Who is Participating?

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

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

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

consultantAuthor Commented:
Thanks. I will check this out.
0

OwnerCommented:
Add 0.005 to both PST and GST (old programming trick)
=(D38*0.07)+0.005
WrongGrandTotal.xls
0

consultantAuthor Commented:
Thank you!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.