WHY IS MY CURRENCY SUM ONE PENCE OUT?

[Guest]

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?

 

[Guest]

Hi

Have a look here:
http://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.