Adding VAT fractions

[Scott Ramsey]

Hello All,
I am using a spreadsheet to calculate VAT. Format is set to two decimal
places, have tried number, currency and accounting methods. Formula is
entered as eg: =A8*7/47 (VAT fraction is 7/47). Answers are displayed
correctly to two decimal places but when adding the column, Excel adds
answer to formula NOT answers displayed in cells. So, although technically
correct, answer is usually a penny or two out. I need it to add what is
displayed. Anyone know how to do this?
Thanks
Kirsty.

 

[Bob Phillips]

Scott,

When calculating the VAT, round it to 2 dec places, then it should sum
correctly, that is

=ROUND(A8*7/47,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Arvi Laanemets]

Hi

Formatting doesn't change data - it only changes the way they are displayed.
You have to round the result.

=ROUND(A8*7/47,2)

 

[Scott Ramsey]

Many thanks both. New user, so help very much appreciated. Can see I have a
lot to learn! Happy New Year.