IF Statement for VAT
=A1+IF(B1="Y",C1)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"phill" wrote in message
...
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
|