4 IF criteria

[hsandeep]

4 IF criteria are there:

Output cell E3 (formula required for E3)

IF C3>B3 AND C3>D3, then E3=2
IF C3>B3 AND C3<D3, then E3=1
IF C3<B3 AND C3>D3, then E3=3
IF C3<B3 AND C3<D3, then E3=4

For other answers “” (null) required.

How to accomplish?
Thanks in advance.

 

[BGY23]

<d3, E3="1
<b3 C3="" AND=""><b3 E3="4
=if(and(c3>b3,c3>d3),2,if(and(c3>b3,c3>d3),3,""))

</b3></b3></d3,>

 

[BGY23]

=if(and(c3>b3,c3>d3),2,if(and(c3>b3,c3>??),3,"")

You example loses somthing in line 2 its not clear so where i put ?? you should put your formula. The syntax is here for you anyway.

 

[wideboydixon]

You have to be careful when posting less than and greater than signs on the forum as they get interpreted as HTML tags. I believe your requirements are:

IF C3>B3 AND C3>D3, THEN E3=2
IF C3>B3 AND C3<D3, THEN E3=1
IF C3<B3 AND C3>D3, THEN E3=3
IF C3<B3 AND C3<D3, THEN E3=4
ELSE ""

So this:

Book1
	B	C	D	E
3	2	5	3	2
4	4	5	7	1
5	8	5	1	3
6	6	5	9	4
7	5	5	6
8	6	5	5
Sheet1

Cell Formulas
Range	Formula
E3	=IF(OR(C3=B3,C3=D3),"",CHOOSE(2*(C3>B3)+(C3>D3)+1,4,3,1,2))

WBD

 

[hsandeep]

IF C3>B3 AND C3>D3, THEN E3=2
IF C3>B3 AND C3<D3, THEN E3=1
IF C3<B3 AND C3>D3, THEN E3=3
IF C3<B3 AND C3<D3, THEN E3=4
ELSE ""
[/code]

So this:

	B	C	D	E
3	2	5	3	2
4	4	5	7	1
5	8	5	1	3
6	6	5	9	4
7	5	5	6
8	6	5	5

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E3 =IF(OR(C3=B3,C3=D3),"",CHOOSE(2*(C3>B3)+(C3>D3)+1,4,3,1,2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks wideboydixon, your formula WORKS.