Enter this in A1
=IF(CountA(B1:P1)0,"X","")

"Jim" wrote:

How do I write a formula that will return an x if a range of cells have any
data?

For example I would like A1 to return X, if any of the cells in B1 through
P1 have any data in them.

Thanks