Inv Vat Formula
 

Hi,

I have a column of costs that do not include VAT, i'd like to add another
column that takes this value and adds 17.5% of the cost onto it (therefore
including VAT).

Any ideas for the formula?

Cheers,

Phil

With your cost in say E2, then in F2 enter =IF(E2="","",E2*1.175).
If you want to round at this stage, then change it to
=IF(E2="","",Round(E2*1.175,2)). You can also put your VAT % in a specific
cell, say K1, as .175. In your formula, you can then always refer to this
cell, by replacing the 1.75 with 1+$K$1, to read (E2*(1+$K$1)). If the tax %
changes, you then do not have to change a lot of formulas. You merely change
the value in K1.

"PW11111" wrote:


Hi,

I have a column of costs that do not include VAT, i'd like to add another
column that takes this value and adds 17.5% of the cost onto it (therefore
including VAT).

Any ideas for the formula?

Cheers,

Phil