• Status: Solved
• Priority: Medium
• Security: Public
• Views: 406

# excel 2010 - rounding error - mastwksht

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

master-wksht---rounding-error.xlsx
0
Frank .S
• 2
• 2
1 Solution

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

Building EstimatorAuthor Commented:
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

Analyst ProgrammerCommented:
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

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

EngineerCommented:
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
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.