I have created a worksheet and put in a formula to add together 4 cells.
the resulting total is 1p less than when I add it together manually.
How can this be?



--
kinsey

See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
kinsey wrote:

I have created a worksheet and put in a formula to add together 4 cells.
the resulting total is 1p less than when I add it together manually.
How can this be?

Many thanks, how do I change this in 2007 version?
--
kinsey


"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
kinsey wrote:

I have created a worksheet and put in a formula to add together 4 cells.
the resulting total is 1p less than when I add it together manually.
How can this be?

What "this"? The page I referred you to has several possible solutions,
most of which work as-is in XL07.

In article ,
kinsey wrote:

Many thanks, how do I change this in 2007 version?

Which aspects of the link you were given did you think were specific to any
earlier version?
--
David Biddulph

"kinsey" wrote in message
...
Many thanks, how do I change this in 2007 version?

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
kinsey wrote:

I have created a worksheet and put in a formula to add together 4
cells.
the resulting total is 1p less than when I add it together manually.
How can this be?