A
Amy
I'm trying to keep a grain record book in excel and so far it's worked great.
I've noticed however that my totals have been off. I start by multiplying
the bushels sold by the price per bushel to get a price. I do this for all
of my entries and it works fine. I then add all of my prices together to get
a grand total and this is where the problem is.
To get the total I use =SUM (I16:I21) which give me a total of $11,756.52.
The problem is it should be $11,756.53. When I use the same formula to get
the total, but manually type in what the prices should be, the answer comes
out $11,756.53. Why does using cells with formula totals vs cells with
manually typed totals differ? The amounts being added are the same?! Can
someone please explain this?
I've noticed however that my totals have been off. I start by multiplying
the bushels sold by the price per bushel to get a price. I do this for all
of my entries and it works fine. I then add all of my prices together to get
a grand total and this is where the problem is.
To get the total I use =SUM (I16:I21) which give me a total of $11,756.52.
The problem is it should be $11,756.53. When I use the same formula to get
the total, but manually type in what the prices should be, the answer comes
out $11,756.53. Why does using cells with formula totals vs cells with
manually typed totals differ? The amounts being added are the same?! Can
someone please explain this?