Donate SIGN UP

Excell

Avatar Image
chumphr | 16:46 Mon 04th Feb 2008 | Computers
2 Answers
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!!!!
Gravatar

Answers

1 to 2 of 2rss feed

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.
dont know but i just tried it and it works on mine. try entering the formula not the autosum or try change cells then try it.
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)

1 to 2 of 2rss feed

Do you know the answer?

Excell

Answer Question >>