Thread
:
IF Statement for VAT
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
IF Statement for VAT
Assuming that you want to calculate the VAT and it is 17.5% then in C2
enter:
=IF(UPPER(B2)="Y",ROUND(A2*17.5%,2),"")
and in D2:
=A2+IF(C2<"",C2,0)
If you perferyou can replace the "" with 0
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"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
Reply With Quote