How to check if all cells in a non congruent range/list meet specific criteria. See below.

spinaz0070 

{TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE,TRUE}

The above is the result of the evaluation of:

ISODD(ROW(C17:C93))

This means that the odd and even rows are determined by ISODD(ROW(C17:C93)) and this hasn't to be done again with the first two conditions.

This is the original formula.

=IF(SUM(IF((C17:C93>225)*(C17:C93<384)*ISODD(ROW(C17:C93)),1,0))=39,"PASS","FAIL")

This is the inner IF formula perhaps more readable with some spaces:

IF(  (C17:C93>225)*(C17:C93<384)*ISODD(ROW(C17:C93))    ,    1,      0)

The   ,    1,      0) aren't within the ISODD(ROW)  condition.

Within IF this

(C17:C93>225)*(C17:C93<384)*ISODD(ROW(C17:C93))

is the condition which is checked and if it's true then 1 is returned and if false 0 is returned.

Below is what the evaluation of 

IF(  (C17:C93>225)*(C17:C93<384)*ISODD(ROW(C17:C93))    ,    1,      0)

returns in the formula bar.