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")

Mangesh

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

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

Biff

"will.00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>