If Else Condition

[varunwalla]

If column A contains buy then the value of the column d & e should be added esle part would be i.e if column a contain sell then the column d & e should be subtracted i am get to work for number i.e by using the formula after googling =IF(B2>5,C2+D2,C2-D2) i am looking for similar type or alternative / efficient way based on the text

here is the preview

Learn-IF-Condition.xlsx
	A	B	C	D	E	F
1	Order Type	Qty	Price	Total	Tax	Grand Total
2	Buy	10	25	250	5	275
3	Buy	5	25	125	5	-100
4	Buy	5	25	125	5
5	Sell	10	25	250	5
6	Sell	10	25	250	5
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=IF(B2>5,C2+D2,C2-D2)
D2:D6	D2	=(B2*C2)

 

[Fluff]

Maybe
=IF(A2="Buy",D2+E2,IF(A2="Sell",D2-E2,""))

 

[varunwalla]

thanks works perfectly

 

[Fluff]

You're welcome & thanks for the feedback.

 

[varunwalla]

Is it possible to highlight entire row with green color if Sell is present

 

[Fluff]

Yes you can use conditional formatting to do that.

 

[CA_Punit]

Book1
	A	B	C	D	E	F
1	Order Type	Qty	Price	Total	Tax	Grand Total
2	Buy	10	25	250	5	275
3	Buy	5	25	125	5	-100
4	Buy	5	25	125	5
5	Sell	10	25	250	5
6	Sell	10	25	250	5
Sheet2

Cell Formulas
Range	Formula
F2:F3	F2	=IF(B2>5,C2+D2,C2-D2)
D2:D6	D2	=(B2*C2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F6	Expression	=IF($A2="SELL",TRUE)	text	NO

Conditional Fomatting

 

[Fluff]

You don't need to use If in CF, just use
=$A2="Sell"