View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phill
 
Posts: n/a
Default IF Statement for VAT

Hi

I have a spreadsheet that i input prices onto and want to have the option of
specifying whether to apply VAT or not. i have 4 colums A,B,C,D. A is the
price of the part, B is either Y or N for VAT, C is the VAT amount and D is
the total with the part and VAT if applicable. is there an IF statement that
can generate this info if i put in the price and either Y or N for VAT?

Many Thanks

Phill