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