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

Try

= if(B1 = "Y", A1+C1, A1)

in cell D1


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=551201

=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

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

Without IF
=A1+C1*(B1="Y")

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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