S
Sam Goddard
Hello,
I have noticed that Excel 2003 does not always calculate figures correctly.
I have been trying to total up an invoice by having a subtotal & a VAT cell
(VAT being the subtotal plus 17.5%). Being as VAT is 17.5%, the figure
calculates is sometimes a half penny.
When it comes to adding these two cells together, if they are £40.02 &
£10.03, I might get a total of 50.06. I assume that this is because,
although the cells are formatted to two decimal places, when excel adds two
cells together, it adds formulae rather than the figures.
Can anybody tell me give me more help & possibly suggest a solution so that
these two cells will add up correctly?
Thanks
Sam
I have noticed that Excel 2003 does not always calculate figures correctly.
I have been trying to total up an invoice by having a subtotal & a VAT cell
(VAT being the subtotal plus 17.5%). Being as VAT is 17.5%, the figure
calculates is sometimes a half penny.
When it comes to adding these two cells together, if they are £40.02 &
£10.03, I might get a total of 50.06. I assume that this is because,
although the cells are formatted to two decimal places, when excel adds two
cells together, it adds formulae rather than the figures.
Can anybody tell me give me more help & possibly suggest a solution so that
these two cells will add up correctly?
Thanks
Sam