I have a formula that totals 100% in Excel, yet same set of numbers input in Access gives a total of 100.00005%. Excel appears to be more accurate.
How do I get Access to give me the same total?
Answer must be in 5 decimal places. I have checked for rounding differences, which would apply only in excel where some of these numbers are the result of a formula, and woud only make a possible difference of .00001. However, in Access I am entering values only, so this doesn't really apply. Numbers in Access are entered as percent (i.e. 1% is entered as .01), but even if I do this in Excel, I get the same answer.
Here's the numbers:
81.36695
2.00000
.80000
5.00000
.25000
.10000
.23750
2.11000
1.77500
.90000
1.40000
.35000
.20000
.10000
.01000
.00010
1.00000
.90000
.05000
.00045
1.40383
.00145
.00203
.04269
Thanks for any possible help!
How do I get Access to give me the same total?
Answer must be in 5 decimal places. I have checked for rounding differences, which would apply only in excel where some of these numbers are the result of a formula, and woud only make a possible difference of .00001. However, in Access I am entering values only, so this doesn't really apply. Numbers in Access are entered as percent (i.e. 1% is entered as .01), but even if I do this in Excel, I get the same answer.
Here's the numbers:
81.36695
2.00000
.80000
5.00000
.25000
.10000
.23750
2.11000
1.77500
.90000
1.40000
.35000
.20000
.10000
.01000
.00010
1.00000
.90000
.05000
.00045
1.40383
.00145
.00203
.04269
Thanks for any possible help!