Using ranges (vs. single cell references) in Excel equalities and inequalities
Posted on 2012-04-06
On some occasions, I see excel formulas containing equalities or inequalities (e.g. >, <, <>, etc.) which include ranges rather than single cell references. I am comfortable with the single cell references such as:
but I'm puzzled by those containing ranges:
What exactly does that mean? Does it mean that at least one cell in the range is not blank or does it mean that all cells in the range are not blank? Or does it mean something else entirely?
If anyone can provide an explanation or insights regarding this concept (or point me to a location that does), I would be very grateful.