If Then

[Jim]

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

 

[Sheeloo]

Enter this in A1
=IF(CountA(B11)>0,"X","")

 

[Rick Rothstein]

Another possibility...

=LEFT("X",COUNTA(B11)>0)