View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tania
 
Posts: n/a
Default WHY IS MY CURRENCY SUM ONE PENCE OUT?

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?