(Arguably, rounding G7 is unnecessary if we round F3, at least for the example Excel file. Only you can decide if and where to explicitly round Excel calculations. To demonstrate, if we enter 1*77.81*4* 38.85714 into the calculator (and display only 2 decimal places), the result appears to be $12,093.90 - the same as G7.Īnd BTW, G7 only appears to be $12,093.90 because of the cell format. And that is the value that Excel uses in the calculation. The problem is: F3 only appears to be 39 because of the cell format. B7 is 1, C7 is 77.81, H7 is 4, and F3 appears to be 39.
You neglect to provide even a single example of the Excel result vs the calculator result.īut we might guess that you are making a very common mistake: when you enter values into the calculator, you enter them as they are displayed in Excel.īut the displayed values might be different from the actual values and Excel uses the actual values in calculations.įor example, the formula in G7 is =B7*C7*H7*F3.
``Very simple formula checked against a calculate and the answer is significantly incorrect``
0 kommentar(er)
