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

x
?
Solved

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

Posted on 2015-01-15
6
Medium Priority
?
88 Views
Last Modified: 2015-01-21
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
Comment
Question by:techcity
  • 3
  • 2
6 Comments
 
LVL 27

Accepted Solution

by:
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

by:techcity
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

by:Shaun Kline
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)

Open in new window

0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 1

Author Comment

by:techcity
ID: 40552031
Thanks. I will check this out.
0
 
LVL 84

Assisted Solution

by:David Johnson, CD, MVP
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

by:techcity
ID: 40562637
Thank you!!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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…
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question