Calculations not 100% accurate

[mike7]

If you can help, it would be very appreciated.

As you can see in the attached picture, I've done a few calculations on a report from the field W contained in a table and you may realize that W should be equal to X + Y + Z. But, if you refer to the same picture, you can see that it's not the case on the first row of results.

Is there a way to modify my formulas to obtain a result 100% accurate to the nearest cent ?

Thanks,

Mike

 

[KenHigg]

3500 / 1.1502487823795032239830157551219 = 3042.82

???
kh

 

[mike7]

a little mistake

As I can see, I made a little mistake in the attached picture in my previous msg. It should have been 1,15025 instead of 1,015025.

Nevertheless, do you believe it corrects the problem simply by using a longer divider ?

Mike

 

[KenHigg]

Worked rounding to .00 with 1.15025 in a spreadsheet.

???
ken