How to force a formula to round numbers while calculating.

**sabotage628** · 11-07-2013, 07:37 PM

Hi. I have an excel formula that is pulling data from another worksheet and using it in a couple different ways. Excel is rounding the results to 10 decimals to calculate and I cannot figure out how to change that.

For example,
=(E18/INDEX(WORKSHEET!C3:C71,(MATCH(G18,WORKSHEET!A3:A71,0))))*G3
Where E18 is 100, IndexMatch is returning a value of 180, and G3 is 1538
When I do the math 100/180 = .56 * 1538 = 861.28
Excel does the same, except .5555555556 * 1538 = 854.45

How do I make it so excel only rounds the calculation to 2 decimals & returns 861.28, not 854.45?

**daddylonglegs** · 11-07-2013, 07:44 PM

It seems to me that if you round at that point you'll be losing accuracy......but if that's what you want try this

=ROUND(E18/INDEX(WORKSHEET!C3:C71,MATCH(G18,WORKSHEET!A3:A71,0)),2)*G3

**sabotage628** · 11-07-2013, 07:49 PM

You are wonderful. It is less accurate, but my boss wants it to come out the same way he does it on his calculator. Oh well, nothing I can do. Thanks so much. I tried =ROUND, but I put the 2 in the wrong spot, so I really appreciate the help.