=AND(ISBLANK(H1:Z40))
GlennUK said:Hi NBVC, that only gives the answer for the first cell in the range.
To find out if the entire range is blank, use:
entered using Ctrl-Shift-Enter instead of Enter.Code:=AND(ISBLANK(H1:Z40))
GlennUK said:Hi NBVC,
test your tests again. For your formula, if the first cell is blank a TRUE is returned, even if there are non-blank cells in the range. So, your formula does not work just like mine.
=AND(AND(ISBLANK(F3:H3)),AND(ISBLANK(J2:L2)))