thanks for the help!
"Rowan" wrote:
Actually =IF(A1:A81,"True","False") will work if you enter it as an
array formula i.e commit it with Ctrl+Shift+Enter.
Otherwise you could use something like:
=IF(COUNTIF(A1:A8,"<2")=0,"True","False")
Regards
Rowan
matt wrote:
I need to know that all cells individually meet the criteria. So in this
case, 2 is greater than 1, so is 3, so is 6, etc, and so in this case all
cells are greater than 1. I want to know if i can write something like
IF(A1:A8=1,"TRUE","false")
I know this format doesn't work, but I think you see what I'm getting at.
"matt" wrote:
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?
|