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?

--Are these calulated results? (I6:I21)

--Increase decimals for the range I16:I21 and see whether what you see is
actually formatted to display less decimals..

If this post helps click Yes
---------------
Jacob Skaria


"Amy" wrote:

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?

Sounds like a rounding issue. The actual value in the cells may be slightly
different (have more decimal places) than what you see. Try putting your
price x number of bushels formula (let's pretend it is =A*B) inside a ROUND
function like this:

=ROUND(A*B,2)

This will round the value to exactly 2 decimal places. Then the SUM function
should give the result you expect.

Hope this helps,

Hutch

"Amy" wrote:

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?