Hi!

Try this:

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

Biff

"will.00" wrote in
message ...

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


--
will.00
------------------------------------------------------------------------
will.00's Profile:
http://www.excelforum.com/member.php...o&userid=24320
View this thread: http://www.excelforum.com/showthread...hreadid=379936