Cable Forum - View Single Post

04-01-2011, 21:09

Hi,

In my Excel expenses sheet I have a sum which works out the VAT on expenses - at the moment it reads: =SUM(E13/1.175) which is 17.5%.

Yeah - you know what I'm about to ask! How do I change it to 20%?

Should it read: =SUM(E13/1.200)?

04-01-2011, 21:09	#1
LSainsbury Guest Location: Near Hungerford, West Berkshire Services: TV: Sky HD, Landline: BT, Mobile: Orange, Internet: Quite Slow! Posts: n/a	Excel % Question Hi, In my Excel expenses sheet I have a sum which works out the VAT on expenses - at the moment it reads: =SUM(E13/1.175) which is 17.5%. Yeah - you know what I'm about to ask! How do I change it to 20%? Should it read: =SUM(E13/1.200)?