IF with two conditions

[Salamullah]

Hi

I need formula with if command in column E based on data from A to D, Secondary no Discount

Segment	Transmission	Value	Discount %	Result
Primary	AUTO	1000	20%	200
Primary​ <strike></strike>	MANUAL	1000	10%	100
Secondary	AUTO	1000	0%	0
Secondary​ <strike></strike>	MANUAL	1000	0%	0

<tbody>
</tbody>

Thanks in advance

 

[Peter_SSs]

Why do you need an IF statement at all?

Excel 2016
	A	B	C	D	E
1	Segment	Transmission	Value	Discount %	Result
2	Primary	AUTO	1000	20%	200
3	Primary	MANUAL	1000	10%	100
4	Secondary	AUTO	1000	0%	0
5	Secondary	MANUAL	1000	0%	0
Discount

Cell Formulas
Range	Formula
E2	=D2*C2

 

[Salamullah]

because column D is given as a sample to understand I have only 1st 3 columns with a fixed discount percentages

 

[Peter_SSs]

because column D is given as a sample to understand I have only 1st 3 columns with a fixed discount percentages

Hmm, you originally said "command in column E based on data from A to D" so it certainly sounded like column D had data.

So try this then

Excel Workbook
	A	B	C	D	E
1	Segment	Transmission	Value	Discount %	Result
2	Primary	AUTO	1000	20%	200
3	Primary	MANUAL	1000	10%	100
4	Secondary	AUTO	1000	0%	0
5	Secondary	MANUAL	1000	0%	0
6
Discount

 

[SQUIDD]

like this perhaps

=IF(A2="secondary",C2,D2*C2)

Dave

 

[Salamullah]

Hi thanks its working,

Can I request to add 1 more condition in the formula, column inserted in C "Source", if Imported than zero % discount

 

[Salamullah]

Segment	Transmission	Source	Value	Discount %	Result
Primary	AUTO	Loc	1000	20%	200
Primary	MANUAL	Loc	1000	10%	100
Primary	AUTO	Imp	1000	20%	0
Secondary	AUTO	Imp	1000	0%	0
Secondary	MANUAL	Loc	1000	0%	0

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Can I request to add 1 more condition in the formula, column inserted in C "Source", if Imported than zero % discount

Segment	Transmission	Source	Value	Discount %	Result
Primary	AUTO	Loc	1000	20%	200
Primary	MANUAL	Loc	1000	10%	100
Primary	AUTO	Imp	1000	20%	0
Secondary	AUTO	Imp	1000	0%	0
Secondary	MANUAL	Loc	1000	0%	0

<colgroup><col><col><col span="4"></colgroup>

In that case, shouldn't that red 20% be 0%?

Excel Workbook
	A	B	C	D	E	F
1	Segment	Transmission	Source	Value	Discount %	Result
2	Primary	AUTO	Loc	1000	20%	200
3	Primary	MANUAL	Loc	1000	10%	100
4	Primary	AUTO	Imp	1000	0%	0
5	Secondary	AUTO	Imp	1000	0%	0
6	Secondary	MANUAL	Loc	1000	0%	0
Discount (2)

 

[Salamullah]

Yes correct and thanks for the quick solution

 

[Peter_SSs]

Yes correct and thanks for the quick solution

Cheers. You're welcome.