Excel 2007 : IF formula needed to verify range of data

[dretwann]

I have the following formula in my spreadsheet:

=IF(AND(H11:H50>=-1,H11:H50<=1),"Pass","Fail")

This is MEANT to read, H11 thru H50 are within -1 to 1, then Pass, otherwise Fail. However, the formula is not working as is and I am not sure where the error lies. I have tried different variations. Is the question I am asking even possible? I can do it the long way, but I figured there must be a shorthand method to arrive at the same answer.

Thanks,

[NBVC]

Try:

=IF(SUMPRODUCT(--(H11:H50>=-1),--(H11:H50<=1))=COUNT(H11:H50),"Pass","Fail")

[dretwann]

Wow! Thanks. This did the trick.