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?

What should happen if there is content?

Try something like this:

=IF(COUNTA(B6:N6),do_something,A6)

You need to define what you want for do_something.

--
Biff
Microsoft Excel MVP


"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?

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?

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?

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?

Are you sure that the cells are actually empty, and that they don't have
spaces or empty strings in them? Check them with ISTEXT.
--
David Biddulph

"Twishlist" wrote in message
...
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?

Yep, that was it. Couldn't see anything, but cleared all the contents of
these cells to be on the safe side and both these clever formulas worked
perfectly...thanks, David.

"David Biddulph" wrote:

Are you sure that the cells are actually empty, and that they don't have
spaces or empty strings in them? Check them with ISTEXT.
--
David Biddulph

"Twishlist" wrote in message
...
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?