# Matching 3 conditions

#### hsandeep

##### Well-known Member
Can someone help me with a formula in column D to generate 'Result' meeting 3 conditions?
Sheet1

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

<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

Last edited:

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
It is not clear what your exhibit is telling and what you are asking "'Result' meeting 3 conditions".

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

Reposted..
Sheet1

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

<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

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

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

Hi Sandeep

I think B < C in condition 6

Try,

Code:
``=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

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

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

Replies
8
Views
168
Replies
6
Views
221
Replies
6
Views
824
Replies
7
Views
282
Replies
4
Views
319

1,221,507
Messages
6,160,213
Members
451,630
Latest member
zxhathust

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back