I have a formula where I am checking for a range of cells whether or not they are blank.
If all of them are blank I want to return another blank.
If any of the cells in the range are not blank, I want to return a value Major Milestone Due
.
Here is the formula I currently have:
=IF(ISBLANK(BM2:BQ2),"","Major Milestone Due")
It is returning everything as Major Milestone Due
, even if there are certain row ranges with all blank cells.