# Multiple column scenarios

#### Caly

##### New Member
Hi I have multiple columns each with a section of data to feed into the criteria. 3 various prices that based on their 3 associated columns will have either yes or no. This results in multiple scenarios. Example is below of the formula but is there an easier way to write this formula?

=If(and(Price A=Yes,price b=yes,price c=yes), Min(price a, price b, price c),
If(and(Price a=no, price b=yes, price c=yes), min(price b, price c),
If(and(Price a=yes,price b=no,price c=yes), min(price a, price c),
If(and(price a=yes, price b=yes, price c=no),
Min(price a, price b),
If(and(Price a=yes,price b=no,price c=no), price a,
If(and(Price a=no,price b=yes,price c=no), price b,
If(and(Price a=no,price b=no,price c=yes), price c,
“Check”

#### AlanY

##### Well-known Member
similar to Fluff's suggestion

Book1
ABCDEFGHIJKLMN
1Price APrice A OK?Price BPrice B OK?Price CPrice C OK?
25Yes6Yes7Yes55
35No6Yes7Yes66
45Yes6No7Yes55
55No6No7Yes77
65No6Yes7No66
75Yes6Yes7Yes55
Sheet1
Cell Formulas
RangeFormula
M2:M7M2=MIN(IF(D2="YES",A2,1000000),IF(H2="YES",E2,1000000),IF(L2="YES",I2,1000000))
N2:N7N2=MIN(IF(D2:L2="Yes",A2:I2))
Press CTRL+SHIFT+ENTER to enter array formulas.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Replies
6
Views
80
Replies
2
Views
34
Replies
7
Views
302
Replies
3
Views
43
Replies
5
Views
74

1,130,407
Messages
5,641,955
Members
417,249
Latest member
serrulate

### 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