Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement for VAT
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement for VAT
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement that does nothing when false | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |