If Then
 

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

If Then
 

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

If Then
 

Another possibility...

=LEFT("X",COUNTA(B1:P1)0)

--
Rick (MVP - Excel)


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