A true/false formula for all individual cells in a range exceed a given value?

**rrbest** · 05-12-2011, 06:48 PM

Say I have 60 cells with varying values and I want another cell to state True or False if ALL cells exceed 10. How could I implement this into a simple formula?

Example

A1: 10
A2: 15
A3: 9
A4: 20

The formula asking if the range A1:A4 all have values that are >= 10 would be false.

Thanks in advance.

**ConneXionLost** · 05-12-2011, 06:52 PM

Hi rrbest,

How about:

=MIN(A1:A4)>=10

Cheers,

**Paul** · 05-12-2011, 06:53 PM

Hi Rrbest,

Perhaps this will work for you:

=COUNTIF(A1:A4,">=10")=COUNT(A1:A4)

**rrbest** · 05-12-2011, 07:01 PM

Very elegant solution, ConneXionLost. This solution worked great. Paul, I didn't get to use your solution, but I appreciate your help. Reputation for both of you.