IF scenario for a range

W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT or SUMIF if any values in a range equal any values in another range 3
Counts all cell containing even numbers in the range 5
VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) 3
ME, STRANGE SUMMATION 3
Conditional formating -identify blank cell 3
Value based cell matching range 8
RAND function without duplicates? 3
Using a range as value_if_true in IF function 14

Top