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

sphami

New Member
Joined
Jan 16, 2010
Messages
4
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
Joined
Feb 11, 2006
Messages
149
=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
Joined
Jan 14, 2009
Messages
2,316
Try this:
Code:
D7: =IF(MIN(E12,I12,M12,Q12)>=D5,"YES","NO")
Does that help?
 

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
In D7:

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

sphami

New Member
Joined
Jan 16, 2010
Messages
4
All formulaes work. I am a Dummy I was just forgetting the ")" after the and!
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top