MS EXCEL, the formula is correct, but the result is incorrect. Please help!

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
Y YconsultantAsked:
Who is Participating?
 
Shaun KlineLead Software EngineerCommented:
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
 
Y YconsultantAuthor Commented:
Thanks Shaun
How can I add "round" function? Can you please instruct me more details?
I do not know Excel much :-(
0
 
Shaun KlineLead Software EngineerCommented:
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)

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Y YconsultantAuthor Commented:
Thanks. I will check this out.
0
 
David Johnson, CD, MVPOwnerCommented:
Add 0.005 to both PST and GST (old programming trick)
=(D38*0.07)+0.005
WrongGrandTotal.xls
0
 
Y YconsultantAuthor 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.

All Courses

From novice to tech pro — start learning today.