Help!!! Excel

[coolme2k]

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]

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.

 

[Luke]

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.

 

[poggy]

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

 

[coolme2k]

Ive done it. Cheers people

 

[bulldog5046]

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..