Forum Discussion
Excel calculating wrong answer
First, the Excel expression for e^(-1) should be EXP(-1) or EXP(-B3), where B3=1.
That displays 0.367879441171442, which truncates (!) to 0.36787.
Second, you should not use or show us rounded (much less truncated) numbers, if you want the most accurate result, especially if your calculator has a button labeled "e" or "exp".
In Excel, "e" is EXP(1), which displays 2.71828182845905. (It is exactly 2.71828182845905 - 4.88E-15. But most people do not know how to see the residual value 4.88E-15.
Although that does round to 2.7183, note that 2.7183^(-1) or more simply 1/2.7183 displays 0.36787698193724, which is less than EXP(-1).
Finally, I doubt that there is any significant difference if you use cell references, unless the actual cell values are different to 15 significant digits, like the rounded and truncated values that you posted.
However, 0.35464 is the rounded or truncated result of a value between 1/2.81968137600452 and 1/2.81980064009475. That does not include EXP(-1), which again is 1/2.71828182845905.
So the likely explanation for your seeing 0.35464 is: it is the result of a typo or some other mistake.
