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

[sphami]

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!

 

[3LeggedDog]

=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]

Try this:

D7: =IF(MIN(E12,I12,M12,Q12)>=D5,"YES","NO")

Does that help?

 

[jbeaucaire]

In D7:

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

 

[sphami]

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