[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

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

please assist
master-wksht---rounding-error.xlsx
0
Frank .S
Asked:
Frank .S
  • 2
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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
 
Frank .SBuilding 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
 
Peter KwanCommented:
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
 
Frank .SBuilding EstimatorAuthor Commented:
hi pkwan, when i use your last 2 formulas it produces "0.00" as a qty for me.
0
 
Saqib Husain, SyedEngineerCommented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now