If statement for a range

[kingofaces]

I've been trying to tackle this issue for awhile but haven't had any luck. It seems like there should be a simple solution, so hopefully someone knows right off the bat what I need.

I have a range I want to check and see if all values in the range are greater than 9000. However the closest I've been able to get is:

=IF(M1:M16>9000,TRUE,FALSE)

However, this returns true if just one value is over 9000. I only want the IF statement to return TRUE if every value in listed range is over 9000. Any ideas? It feels like it's something obvious I'm missing just because I've been spending too long on it.

*I know I could do a workaround in VBA, but it seems like a roundabout way if there's a straightforward way to do it right in Excel.

 

[VoG]

Try

=MIN(M1:M16)>9000

 

[markf5998]

=IF(COUNTIF(M1:M16,">9000")=COUNT(M1:M16),"True","False")

but the response above is better!

 

[kingofaces]

Wow, yeah I was right about completely missing something obvious. Thanks VoG.