Try:
=if(or(istext($L2),istext($L3),istext($L4)),'Data Report!N3,J11)

HTH,

"s2frost" wrote:

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.