Forum Discussion
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 adding two Dollar amounts...
(G10) $58.83-$55.00= $3.82999999999998 (to see it I have to go 14 decimals over less then that it rounds up.)
Okay I use this for My bank statements...
Line
A = space holder and is not involved in any formula.
B = the check # and is not involved in any formula.
C = the date and is not involved in any formula.
D = Description and is not involve in any formula.
E = I manually put in a $ Dollar amount example $23.19 (the amount I put into the bank...)
F = I manually put in the $ amount Example $23.19 (the amount I spent or took out of the bank)
G = Excel figures this is If I am on line Example G10 = (G9+E10-F10)
H = Checkmarks for after the statement is checked and is not involved in any formula.
I = Checkmarks when I balances online and is not involved in any formula.
J = E (above)
K= F (above)
L= Excel figures this is If I am on line Example L10 = (L9+J10-K10)
M = is my check to make sure my Accounts I don't have added in the first side balances out I checks to see if L=G+N if true = "T", if false = (amount G-L) Example M10 =IF(L10=G10+N10,"T",G10-L10)
N = T+X+AB Excel adds
O = I manually put in the amount on the statement
P = O-L (excel subtracts)
Q = space holder and is not involved in any formula.
R= I manually put in a $ Dollar amount
S = I manually put in a $ Dollar amount example
T = Excel figures this is If I am on line Example T10 = (T9-R10+S10)
U = space holder and is not involved in any formula.
V = I manually put in a $ Dollar amount
W = I manually put in a $ Dollar amount example
X = Excel figures this is If I am on line Example X10 = (X9-V10+W10)
Y = space holder and is not involved in any formula.
Z = I manually put in a $ Dollar amount
AA = I manually put in a $ Dollar amount example
AB = Excel figures this is If I am on line Example AB10 = (AB9-Z10+AA10)
So my question is how can G have more digits decimals then the two?? When I am add only have cents .XX how does it get .XXXXXXXXXXXXXX???? This
Is my formulas to simple for it???? Am I wrong??
Please help..
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.
5 Replies
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.
SergeiBaklan Thank you, for your time... I appreciate you for taking you time to help. that looks to be it...
Is there an update to correct this... How can I tell what version I am using....
And Is there a easy way to add the rounding to all?
Looks like I got to do it with 3 different collums
hank you again..
You may put such formula into the cell G3 and drag it down till end of the table. Play with this on the copy of your file.
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...
