I have 3 cells that may or may not contain text my statement is the following:
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)). What I need to
happen is to have N3 posted in the cell of this formula if any of the three
cells have text in them. I feel I am close but not quite there. The
response I get is works only if all L2:L4 is FALSE,FALSE,FALSE or TRUE,TRUE,
TRUE.
Help is appreciated.
Bookmarks