# Calc: Checking whether a range of cells are blank via a formula [closed]

I'm trying to create a formula that checks whether a range of cells above it are blank.

Ie, =IF(AND(E21>$C$16, $H$21:H22="");"Here!";"")

gives a #value error. Using F9 I found the error is $H$21:H22="". It works for a single cell, so I assume you can't check a range this way. So how do I do it?

Background: Simple physics spreadsheet. Each row increments a calculation, I want a flag to draw my attention to the spot where the calculation swings from negative to positive. Using =IF(E21>$C$16;"Here!";"") works, but then it has "Here!" on *every* positive row.

ie,

.

Here!

Here!

Here!

Here!

I would prefer to only have it appear once, on the first row it flips:

.

Here!

.

.

.