# multiple cell lookup for "Yes","No" results

#### sphami

##### New Member
I am trying to create a sheet that allows one to forecast incomes and it looks at multiple locations. The last formula I am having problems with is this. I need to look-up total values in a cell that has summed monthly revenues for a quarter. I want to look at 4 cells and if any one of them do not equal or exceed a number I want the argument to return with a "NO", if they all exceed I want it to return with a "Yes".

For instance:

Cell D5 = quarterly quota of \$135,000
Cells E12, I12, M12 & Q12 each have quarterly totals
Cell D7 tell you whether you have reached quota or not in ALL quarters

if cells e12, I12 & M12 all reach at or over 135,00 but cell Q12 is under 135,00 I want cell D7 to read NO

If they all are greater or equal to 135,000 I want D7 to read YES

Thanks, I feel brain dead on this one!

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### 3LeggedDog

##### Board Regular
=if(and(E12>=D5,I12>=D5,M12>=D5,Q12>=D5),"Yes","No")

"And" requires that each condition be met.

The first value after the condition (in this case, "Yes") is what is returned if the condition is true. The second value is what is returned if the condition is false.

#### Ron Coderre

##### MrExcel MVP
Try this:
Code:
``D7: =IF(MIN(E12,I12,M12,Q12)>=D5,"YES","NO")``
Does that help?

#### jbeaucaire

##### Well-known Member
In D7:

=IF(AND(E12>=\$D\$5,I12>=\$D\$5,M12>=\$D\$5,Q12>=\$D\$5), "Yes", "No")

#### sphami

##### New Member
All formulaes work. I am a Dummy I was just forgetting the ")" after the and!

Replies
7
Views
156
Replies
0
Views
171
Replies
3
Views
85
Replies
4
Views
852
Replies
1
Views
646

1,136,731
Messages
5,677,420
Members
419,692
Latest member
Also_Confused

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