Really appreciate your replies. OK, I've tried both suggestions on a row
where A4 contains text and there is no content in range B4:O4, with following
result.

=IF(B4:O4="",A4,"") entered as an array, returns no display.
=IF(COUNTA(B4:O4),"",A4) entered as normal function , or as an array,
returns no display
I'm trying to draw out a list of items (Col A) which have no action listed
against them in the columns to their right (B:O) Is it the 'do_something/what
to do here' argument that I'm not grasping?

"Ragdyer" wrote:

Forgot to mention that the formula is an *array* formula.
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
What do you want to do if the range *does* contain data?

=If (B6:N6="",A6,"What To Do Here?")

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Twishlist" wrote in message
...
Would welcome assistance to determine which function I use to check
whether a
range of cells have any content or not, then return a text string from
another cell, if not?