Help!!! Excel

Currently reading:
Help!!! Excel

coolme2k

New member
Joined
Jun 20, 2005
Messages
65
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
 

Stu DemonD

Super LOL!
Joined
Sep 12, 2003
Messages
46,073
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.
 
Joined
Dec 20, 2004
Messages
5,167
Location
Kent
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:

poggy

It was broken, honest
Joined
Sep 24, 2003
Messages
3,156
Location
United Kingdom.
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
 

bulldog5046

faster! FASTER!!!
Joined
May 8, 2005
Messages
9,053
PMSL, this is my mate at college, his name is Toby, just...well...he's a complete slacker like me, dont bother helping him he'll work it out himself in about 10 minutes... and i mean for anything..
 
Top