How to use cell references and defined names in criteria in Excel (61090)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
This article was previously published under Q61090 SUMMARY
In Microsoft Excel, criteria can be set by typing the exact value that
is desired in the criteria cells or by using cell references or
defined names.
To use the value of cell D1 as the criteria, type the following
formula in the criteria cell:
=$D$1
To use the value of a defined name, such as "CritVar", type the
following formula in the criteria cell:
=CritVar
To use the operators, such as less than (<) and greater than (>), the
operator must be concatenated with the formula. For example, to
specify a match of greater than the value in cell D1, type the
following formula in the criteria cell:
=">"&$D$1
To specify a match of greater than or equal to a cell defined as
"GVAR", type the following formula in the criteria cell:
=">="&GVAR
MORE INFORMATION
Quotation marks must be used, otherwise Excel interprets the
information as "greater than "$D$1"" where "$D$1" is a text string.
The same applies for a defined name.
| Modification Type: | Major | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | KB61090 |
|---|
|