View Single Post
Old 07-04-2006, 10:21   #3
yesman
Guest
 
Location: Cambridge
Posts: n/a
Re: Excel: Calculating VAT

Quote:
Originally Posted by lsainsbury
Hello,

Very basic Excel question - I'm sure i've done this before but as it's Friday morning I can't work it out!

I have an expsnses worksheet n Excel.

It has three columns - Net Amount, VAT and Total.

What I want to do is just complete the total column and have Excel work out the Net and VAT amounts...

Any ideas on the simple sum formula?

The net amount would be the total divided by 1.175, then the VAT would be the net amount multiplied by 17.5%

Edit: beaten to it by Paul
  Reply With Quote