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? |
WHY IS MY CURRENCY SUM ONE PENCE OUT?
Hi
Have a look he 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. "Tania" wrote in message ... 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? |
All times are GMT +1. The time now is 05:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com