Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect Currency Displayed | Excel Discussion (Misc queries) | |||
Pence field to currency? | Excel Worksheet Functions | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |