Forum Discussion
Solved
simple math formular (don't understand)
Simple math is off and I don't understand why... Please help.... Sorry going to be long to explain (please stay with me I really need help)... I don't see how it getting a .00000009998 when I am a...
It looks like floating point error Floating-point arithmetic may give inaccurate results in Excel accumulated in column G.
I'd use
=ROUND(G2+E2-F3,2)and drag it down.
Have you checked Number Formatting?
ChrisMendoza Thank you, so much for you time.... I appreciate you!
It formatted as accounting, I also tried Currency.. And numbers (all was the same) right now it is Accounting as I like how the $ BUT how would that effect adding .35 to .32???? wouldn't that always be .67 two digids... not .6699991?? I don't get the math...