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?