# 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

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Replies
7
Views
143
Replies
2
Views
112
Replies
5
Views
111
Replies
9
Views
126
Replies
1
Views
98

1,126,986
Messages
5,621,992
Members
415,873
Latest member
fuulhouse

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