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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Segment[/TD]
[TD]Transmission[/TD]
[TD]Value[/TD]
[TD]Discount %[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Primary
[/TD]
[TD]AUTO[/TD]
[TD]1000[/TD]
[TD]20%[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]

Primary​

<strike></strike>
[/TD]
[TD]MANUAL[/TD]
[TD]1000[/TD]
[TD]10%[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Secondary[/TD]
[TD]AUTO[/TD]
[TD]1000[/TD]
[TD]0%[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]

Secondary​

<strike></strike>
[/TD]
[TD]MANUAL[/TD]
[TD]1000[/TD]
[TD]0%[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

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]

[TABLE="width: 415"]
<colgroup><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Segment[/TD]
[TD]Transmission[/TD]
[TD]Source[/TD]
[TD]Value[/TD]
[TD]Discount %[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]AUTO[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]MANUAL[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]AUTO[/TD]
[TD]Imp[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Secondary[/TD]
[TD]AUTO[/TD]
[TD]Imp[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Secondary[/TD]
[TD]MANUAL[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

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

[TABLE="width: 415"]
<colgroup><col><col><col span="4"></colgroup>[TR]
[TD]Segment[/TD]
[TD]Transmission[/TD]
[TD]Source[/TD]
[TD]Value[/TD]
[TD]Discount %[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]AUTO[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]MANUAL[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Primary[/TD]
[TD]AUTO[/TD]
[TD]Imp[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Secondary[/TD]
[TD]AUTO[/TD]
[TD]Imp[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Secondary[/TD]
[TD]MANUAL[/TD]
[TD]Loc[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[/TABLE]

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.