'IF' formula to test range of cells

[HughT]

Dead simple, but oh so hard!

All I want to do is test if A1:E1 contain anything, and if so, put an 'x' in F1.

I have tried {=IF((A1:E1)>1,"x")} (array formula) but this only works on A1 and ignores the rest of the range. I have also tried various combinations of Countif etc with no joy either.

Any ideas?

Many thanks.

 

[JoeMo]

Dead simple, but oh so hard!

All I want to do is test if A1:E1 contain anything, and if so, put an 'x' in F1.

I have tried {=IF((A1:E1)>1,"x")} (array formula) but this only works on A1 and ignores the rest of the range. I have also tried various combinations of Countif etc with no joy either.

Any ideas?

Many thanks.

In F1:
=IF(COUNTA(A1:E1)>0,"x","")

 

[gaz_chops]

Try

=IF(COUNTA(A1:E1),"X","")

 

[HughT]

Yay!

Been struggling with this all afternoon. Thank you very much!

 

[gaz_chops]

You're welcome.