Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Formula to calculate VAT paid

microsoft excel training - Formula to calculate VAT paid

ResolvedVersion Standard

Wed 9 May 2007, 15:11 Delegate Joel said...

Joel has attended:
Excel Intermediate course

Formula to calculate VAT paid

Is there a formula that I can use to calculate how much VAT that has been paid when the only information I have is the total amount.

e.g. Amount paid =

Wed 9 May 2007, 15:32 Trainer Tracy said...

RE: Formula to calculate VAT paid

Hi Joel

You could try
[CELL] / 1.175 to return the original amount less the vat

or

[CELL]/1.175)*0.175 to return only the Vat.

Hope that helps

Tracy

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft excel training - Formula to calculate VAT paid

Formula to calculate VAT paid

RE: Formula to calculate VAT paid

Excel articles

Excel tip:

Copying Values Without Formulas in Excel 2010