View Full Version : Calculations not 100% accurate


mike7
09-01-2004, 12:30 PM
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
09-01-2004, 12:55 PM
3500 / 1.1502487823795032239830157551219 = 3042.82

???
kh

mike7
09-01-2004, 01:31 PM
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
09-01-2004, 01:54 PM
Worked rounding to .00 with 1.15025 in a spreadsheet.

???
ken