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!
.
.
.