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

[rrbest]

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]

Hi rrbest,

How about:

Please Login or Register  to view this content.

Cheers,

[Paul]

Hi Rrbest,

Perhaps this will work for you:

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

[rrbest]

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.