I have a question that involves the INT function within Access.
I have been using it to do my rounding to the nearest tenth but just have a single anomaly that I cant seem to explain.
My expression is INT(-10*[Price]/(1-[GP]))/-10.
When I ran this against $19.00 with a 5% GP value, it returned $20.10. When I put this into our Excel sheet and take $19.00 and divide it by .95, I get $20.00 even as well as when I simply do it in a calculator.
Can anyone explain why a .10 appeared? At the end of the day it rounded up so it would be in our favor, but I worry that something like that could happen elsewhere and next time it might not just be a dime worth.
I have been using it to do my rounding to the nearest tenth but just have a single anomaly that I cant seem to explain.
My expression is INT(-10*[Price]/(1-[GP]))/-10.
When I ran this against $19.00 with a 5% GP value, it returned $20.10. When I put this into our Excel sheet and take $19.00 and divide it by .95, I get $20.00 even as well as when I simply do it in a calculator.
Can anyone explain why a .10 appeared? At the end of the day it rounded up so it would be in our favor, but I worry that something like that could happen elsewhere and next time it might not just be a dime worth.