Matt,

What does "if each cell is greater" mean? Do you want a count of the cells?
Do you want to know if any meet the criteria (Yes/No)?

--
Earl Kiosterud
www.smokeylake.com

"matt" wrote in message
...
i need to check to see if a given range of cells each fall within a range.
Say I had a column of data like this:

2
3
6
3
4

I want a statement that checks to see if each cell is greater than or
equal
to 1, say. Is there a way I can do this without writing a separate IF
statement for each cell and another IF statement for those results?