Amount minus VAT

S

SnowyHJT

If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT.
I need to enter different amounts in A1, A2 etc. all way down the A Column
and show in the B Column Less 15% VAT.

Any help would be much apreciated.
 
J

Jacob Skaria

Ooops...You are right...Thanks Mike...

Let me go and sleep...

If this post helps click Yes
 
J

Jacob Skaria

Sorry. Use the formula in Mike's post...=(A1/115)*100


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
Working out VAT owed 1
Calculating VAT (value added tax) 2
working VAT in worksheet 8
New VAT Rate 2
HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL 4
Calculating VAT at different rates 6
how can I calculate VAT for selective data in the same column of a 2

Top