Solved

# excel 2010 - rounding error - mastwksht

Posted on 2013-05-12
363 Views
Last Modified: 2013-05-12
hi experts please see attached wksht, I have rounding errors i need help with please.

The errors are in cells G18 and L18,

G18 should = 0.964

and

L18 should = 1.205

please assist
master-wksht---rounding-error.xlsx
0
Question by:FrankSasso
• 2
• 2
5 Comments

LVL 43

Expert Comment

Use this formula in f18

=ROUND(IF(D18="","",D18/\$D\$12+0.001),3)

and this in k18

=ROUND(IF(I18="","",I18/\$D\$12+0.001),3)
0

Author Comment

hi expert, the problem im having with your solution is when i past this formula into another cell then it produces "value" errors when there is no info in column d. I dont understand because the formula says its to shown nothing?
0

LVL 16

Expert Comment

Hi, I think the problem is due to the following:

For example:

G18 = IF(D18="","",F18*\$D\$12)
F18 = IF(D18="","",D18/\$D\$12+0.001)
D18 = 0.82

So
F18 = 0.82/241 + 0.001
G18 = (0.82/241+0.001)*241 = 0.82 + 0.241 = 1.061

The same applies for K18 and L18.

Therefore, if you would like to make G18 to be 0.964, one way is to use:

G18=IF(D18="","",ROUND(F18,3)*\$D\$12)

Same to be applied to L18:
L18=IF(I18="","",ROUND(K18,3)*\$D\$12)
0

Author Comment

hi pkwan, when i use your last 2 formulas it produces "0.00" as a qty for me.
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 300 total points
Change the first set of formulas I gave you to

=IF(D18="","",ROUND(D18/\$D\$12+0.001,3))

and

=IF(I18="","",ROUND(I18/\$D\$12+0.001,3))
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

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

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

#### Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!