View Single Post
Old 07-04-2006, 11:18   #11
LSainsbury
Guest
 
Location: Near Hungerford, West Berkshire
Services: TV: Sky HD, Landline: BT, Mobile: Orange, Internet: Quite Slow!
Posts: n/a
Re: Excel: Calculating VAT

Quote:
Originally Posted by Paul M
Nope.

Imagine if the net was £10, and VAT was 10%, then the total would be £10 + £1 = £11.

However £11 - 10% is £11 - £1.10 = £9.90 - not the same calculation.
I see what you mean! OK - Won't use the % on a calc ever again!

One final thing....how do I copy just the forumla to other cells....paste special formulas dosn't seem to work!
  Reply With Quote