I use Excel 2003 for clients' sales spreadsheets which include VAT
Whenever I set up a new sheet I can never remember how to have the totals added as stated, not rounded up so that the actual additons are incorrect.
Can anyone remind me please?
Replies (4)
Please login or register to join the discussion.
Rounding
If you round the figures at cell level, then the totals will always be correct.
Formula is:
=ROUND((A1),2)
Options -precision as displayed
You might mean this - but be careful it does exactly what it says on the tin
Tools - Options - Calculation tab - tick precision as displayed
More on rounding
Democratus is right to warn about the use of 'Precision as displayed'. There's a lot more on rounding, including a 'Precision as displayed' horror story here: https://www.accountingweb.co.uk/topic/excel-faqs-rounding/493946