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

=IF(SUMPRODUCT(--(A1:Z1100)),"check","ok")

Mangesh


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

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