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?