Forum Discussion
Excel Math
Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers.
Excel therefore stores 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
This could be why you are seeing a difference between your calculator and Excel.
Recommend to use the ROUND function to get the same result.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers.
Excel therefore stores 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
This could be why you are seeing a difference between your calculator and Excel.
Recommend to use the ROUND function to get the same result.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
