Technology1 min ago
Excell
Hi I'm trying to work out VAT (17.5%) in an excell spreadsheet but when I tryv and total the columns at the end they don't add up to the correct values.
For instance two of the total are 159.31 and 665.51 the computer works our the total to be 825.81 and not 825.82 as is should be.
What am I doing wrong!!!!
For instance two of the total are 159.31 and 665.51 the computer works our the total to be 825.81 and not 825.82 as is should be.
What am I doing wrong!!!!
Answers
Best Answer
No best answer has yet been selected by chumphr. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.This is due to the VAT figures not being rounded up or down properly.
Assuming the pre-VAT figures are �135.58 and �566.39 the result of your calculation would yield �159.30650 and �665.50825. These are shown as rounded to the nearest 2nd decimal in the column but are actually treated as the 5 decimal place figure for the sum calculation i.e. �824.81475 which is rounded to the nearest 2nd decimal.
To counteract this behaviour change your formula from
=A1*1.175
to
=ROUND(A1*1.175,2)
Assuming the pre-VAT figures are �135.58 and �566.39 the result of your calculation would yield �159.30650 and �665.50825. These are shown as rounded to the nearest 2nd decimal in the column but are actually treated as the 5 decimal place figure for the sum calculation i.e. �824.81475 which is rounded to the nearest 2nd decimal.
To counteract this behaviour change your formula from
=A1*1.175
to
=ROUND(A1*1.175,2)