quick EXCEL question

[dysfunction]

If you want to know how much VAT is incl in the £117.5 then you have to:

117.5 divide by 1.175. This will give you the amount before the VAT ie 100. The VAt is then the difference between the 100 and the 117.5

Using the =Round(sum here) should get rid of any of your differences.

 

[FatBusinessman]

Oh, and you can ditch the PRODUCT function you're using - it doesn't actually affect the answer, as you're just multiplying one number together (which doesn't achieve anything, really)

=ROUND(F8*(1-1/1.175),2)

is probably the neatest way of doing it (note there is now only a single reference to F8).