View Single Post
  #1   Report Post  
will.00
 
Posts: n/a
Default IF scenario for a range


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