Thread: Evaluating Each Cell

Hi Everyone,

I have what seems to be a simple problem, yet it is stumping me.

I need to be able to evalue a range of cells for two conditions.
Condition 1: Value greater than or equal two 600
Condition 2: Okay for value to be equal to zero or blank
If both conditions are not met in one cell, the whole row fails.

Each cell in the range needs to be evaluated for these conditions.

Here is the layout.
A B C D
1 200 600 1 Failed
2 600 600 700 Passed
3 0 700 900 Passed

I was looking at a formula for Column D using nested IF statements, but couldn't get them to work (1>Value>600). The other complication is that we could end up evaluating up to 12 data points for each row...which violates the nested IF statement limits.

Ideas?

Thanks,
Matt

Hi Matt,

Try this

=IF(AND(COUNT(A1:C1)=3,MIN(A1:C1)<>0,MIN(A1:C1) >=600), TRUE, FALSE)

If you are testing more than 3 columns, change the 3 to more and of course make the range of cells larger.

Hi Matt,
Try this one then:

=IF(AND(OR(A1=0,A1="",A1>=600),OR(B1=0,B1="",B1>=600),OR(C1=0,C1="",C1>=600)),TRUE,FALSE)