Matching 3 conditions

[hsandeep]

Can someone help me with a formula in column D to generate 'Result' meeting 3 conditions?
Thanks in adv.
Sheet1

	A	B	C	D	E	F	G
1				Result	Condition 1	Condition 2	Condition 3
2	300	400	500	1	A<b< td=""></b<>	B<c< td=""></c<>	A<c< td=""></c<>
3	300	600	500	2	A<b< td=""></b<>	B>=C	A<c< td=""></c<>
4	300	400	200	3	A<b< td=""></b<>	B>=C	A>=C
5	300	200	100	4	A>=B	B>=C	A>=C
6	300	200	250	5	A>=B	B<c< td=""></c<>	A>=C
7	300	200	500	6	A>=B	B>=C	A<c< td=""></c<>

<tbody>
</tbody>

E2 condition: A<B
F2 condition: B<C
G2 condition: A<C
E3 condition: A<B
G3 condition: A<C
F6 condition: B<C
G7 condition: A<C

 

[Aladin Akyurek]

It is not clear what your exhibit is telling and what you are asking "'Result' meeting 3 conditions".

 

[hsandeep]

Some formulas did not 'appear' thr' Excel Jeanie so wrote below Aladin.

 

[hsandeep]

Reposted..
Sheet1

	A	B	C	D	E	F	G
1				Result	Condition 1	Condition 2	Condition 3
2	300	400	500	1	A<B	B<C	A<C
3	300	600	500	2	A<B	B>=C	A<C
4	300	400	200	3	A<B	B>=C	A>=C
5	300	200	100	4	A>=B	B>=C	A>=C
6	300	200	250	5	A>=B	B<C	A>=C
7	300	200	500	6	A>=B	B>=C	A<C

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 48px"><col style="WIDTH: 48px"><col style="WIDTH: 48px"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[hsandeep]

FINAL 6 conditions: somehow I wrote it....

6 conditions are there:
Condition 1: A is less than B; B is less than C and A is less than C
Condition 2: A is less than B; B is greater than or equal to C and A is less than C
Condition 3: A is less than B; B is greater than or equal to C and A is greater than or equal to C
Condition 4: A is greater than or equal to B; B is greater than or equal to C and A is greater than or equal to C
Condition 5: A is greater than or equal to B; B is less than C and A is greater than or equal to C
Condition 6: A is greater than or equal to B; B is greater than or equal to C and A is less than C

 

[hsandeep]

I could get your point Aladin it is MATCHING 6 conditions..sorry for inconvenience

 

[vds1]

Hi Sandeep

Please check your condition 6.

I think B < C in condition 6

 

[vds1]

Try,

=IF(AND(A1< B1,B1< C1,A1< C1),1,IF(AND(A1< B1,B1> =C1,A1< C1),2,IF(AND(A1< B1,B1> =C1,A1> =C1),3,IF(AND(A1> =B1,B1> =C1,A1> =C1),4,IF(AND(A1> =B1,B1< C1,A1> =C1),5,IF(AND(A1> =B1,B1< =C1,A1< C1),6,"Not  Met"))))))

Replace space by blank

 

[hsandeep]

It is showing the 'formula' only not the results (1,2,3,4,5,6)

 

[hsandeep]

Thanks vds1 it WORKED. after removing blanks from 'within the formula'.