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
|