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

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #ffff00, align: center"]Result[/TD]
[TD="bgcolor: #99cc00, align: center"]Condition 1[/TD]
[TD="bgcolor: #99cc00, align: center"]Condition 2[/TD]
[TD="bgcolor: #99cc00, align: center"]Condition 3[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]500[/TD]
[TD="bgcolor: #ffff00, align: right"]1[/TD]
[TD="bgcolor: #99cc00"]A<b< td=""></b<>[/TD]
[TD="bgcolor: #99cc00"]B<c< td=""></c<>[/TD]
[TD="bgcolor: #99cc00"]A<c< td=""></c<>[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]500[/TD]
[TD="bgcolor: #ffff00, align: right"]2[/TD]
[TD="bgcolor: #99cc00"]A<b< td=""></b<>[/TD]
[TD="bgcolor: #99cc00"]B>=C[/TD]
[TD="bgcolor: #99cc00"]A<c< td=""></c<>[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]200[/TD]
[TD="bgcolor: #ffff00, align: right"]3[/TD]
[TD="bgcolor: #99cc00"]A<b< td=""></b<>[/TD]
[TD="bgcolor: #99cc00"]B>=C[/TD]
[TD="bgcolor: #99cc00"]A>=C[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]100[/TD]
[TD="bgcolor: #ffff00, align: right"]4[/TD]
[TD="bgcolor: #99cc00"]A>=B[/TD]
[TD="bgcolor: #99cc00"]B>=C[/TD]
[TD="bgcolor: #99cc00"]A>=C[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]250[/TD]
[TD="bgcolor: #ffff00, align: right"]5[/TD]
[TD="bgcolor: #99cc00"]A>=B[/TD]
[TD="bgcolor: #99cc00"]B<c< td=""></c<>[/TD]
[TD="bgcolor: #99cc00"]A>=C[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]500[/TD]
[TD="bgcolor: #ffff00, align: right"]6[/TD]
[TD="bgcolor: #99cc00"]A>=B[/TD]
[TD="bgcolor: #99cc00"]B>=C[/TD]
[TD="bgcolor: #99cc00"]A<c< td=""></c<>[/TD]

</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]

I hate to ask: What is A, what does this refer to?

 

[hsandeep]

A: Value in the cells of column A. I can understand you Aladin..2 mistakes on my part 1: Title should have been '....with 6 conditions" 2: My scripting error.
Apology but I needed it. Any better formula if can be given?