I have a spreadsheet where my calculation ( results ) should be the same as if you were to calculate the same input as on a calculator.
Example :
Cell A = .351
Cell B = 9.444
Cell C = 34.444
When I use the following formula : A / B*C = 1.28011 is my answer
When I calculate the same thing on a calculator my result is 1.28055
This gives me a variance of -0.044% which I cannot "use" because this can cause an incremental increase which I cannot allow for my calculations.
Is there any advice or guidance that anyone can give to help me with this? I basically need my numbers to "match" what will calc out on a calculator for those who do not have access to Excel. Thanks in advance.
Bookmarks