Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-01-15
6
Medium Priority
?
87 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

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

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

722 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