Help!!! Excel

Currently reading:
Help!!! Excel

coolme2k

New member
Joined
Jun 20, 2005
Messages
65
Points
28
Location
Bristol
I know this is exremly random, but is there anyway of writing in a total amount and then the vat and net total comes up automatically. this is drivin me nuts .

heres what it looks like.

Inv No. Inv Date Company TOTAL VAT NET
523 1-Jun-06 49.35 49.35 42.00
524 1-Jun-06 29.38 4.38 25.00
 
Yes - just use a formula :)

If cell A1 is net, then make B1 = +A1*.175 - although this may round, so set it to 2 decimal places.

Then C1 gross can be A1+B1.
 
coolme2k said:
I know this is exremly random, but is there anyway of writing in a total amount and then the vat and net total comes up automatically. this is drivin me nuts .

heres what it looks like.

Inv No. Inv Date Company TOTAL VAT NET
523 1-Jun-06 49.35 49.35 42.00
524 1-Jun-06 29.38 4.38 25.00

You want the total VAT and NET at teh bottom of the colums?
If so, in the empty cell write "=sum(xx:xx)" - Replace the first xx with the first cell reference (in this case would be location of 49.35 under VAT column), and the second xx with the ending cell reference (4.38 in VAT).

Or if not, see stu's post for actually calculating the VAT and NET.
 
Last edited:
If you have the total amount (inc VAT) and the VAT amount, then all you do is subtract the VAT from the total and it will leave you with the nett amount.

i.e

column A is total
column B is VAT

make column C=A-B
 
Back
Top