Help with formula

[simply180]

I need help with an if/then statement. I have columns B thru S and only one column may or may not have an "x". Column T is where I want the if then statement. If a column in a certain row has an "x", I want an "x" to show in column T. If the row has no x's, I want to have a "-" show.

Please help!

 

[VoG]

Try in T1 copied down

=IF(COUNTIF(B1:S1,"x")>0,"x","-")

 

[T. Valko]

I need help with an if/then statement. I have columns B thru S and only one column may or may not have an "x". Column T is where I want the if then statement. If a column in a certain row has an "x", I want an "x" to show in column T. If the row has no x's, I want to have a "-" show.

Please help!

One way...

=IF(COUNT(MATCH("x",B2:S2,0)),"x","-")

 

[simply180]

Thank you very much. It worked perfectly.

 

[T. Valko]

Thank you very much. It worked perfectly.

You're welcome. Thanks for the feedback!