=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response

[Guest]

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.

 

[Guest]

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

HTH,

 

[RagDyeR]

You can just add an OR() to your *array* formula.

=(IF(OR(ISTEXT('Data Report'!$L2:$L4)),'Data Report'!N3,J11))
--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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.