| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create range bar graph | Charts and Charting in Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Linear Mode
