software

im am trying to add cells that are formatted to currency but cant understand
why it is 1p out?

the cells i am adding have a minus formula in them!

the first five cells add up correctly but if i go over that the sum is 1p out?

can anyone help?

Hi

Have a look he
www.mcgimpsey.com/excel/pennyoff.html

It may help - but then again it may not!! If you post some of your
numbers/formulae it would help us!

Cheers.
Andy.

quot;Taniaquot; gt; wrote in message
...
gt; im am trying to add cells that are formatted to currency but cant
gt; understand
gt; why it is 1p out?
gt;
gt; the cells i am adding have a minus formula in them!
gt;
gt; the first five cells add up correctly but if i go over that the sum is 1p
gt; out?
gt;
gt; can anyone help?