IF scenario for a range

[will.00]

The range A1 to Z1 contains random numbers.

If any numbers in the range A1 to Z1 has any number > 100, then "check"
else "ok"

How can I input a formula to a range instead of a cell.


Thanks in Advance

 

[mangesh_yadav]

=IF(SUMPRODUCT(--(A1:Z1>100)),"check","ok")

Manges

 

[Biff]

Hi!

Try this:

=IF(COUNTIF(A1:Z1,">100"),"Check","OK")

Biff