Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |