use value of one cell to determine which formula to use in another

[welshy0204]

Hello,

I am trying to put together a list of products with the unit price, VAT and Sale price.

I have a column that works out VAT on all products, and then one that adds this to the unit price to give the overall cost for the company. I now need to add another column with tax code (mainly 1 or 2). So the table is as follows

Unit price (without VAT), VAT Code, VAT, Unit price & VAT, Sale Price

so, if there is a 1 in the VAT Code colum, the VAT formula needs to calculate VAT (20%), if there is a 2 in the VAT Code column, then this will need to display 0% VAT (or run a slightly different formula if tax is at a percentage other than 0% or 20%).

Does anyone have any ideas on what might work?

Thanks

Rhod

[cbatrody]

Hi,

IF function would work here, for calculating VAT if VAT Code is in column B, then VAT = IF(B2=1,A2*20%, IF(B2=2,A2*xx%,0%))