Determine if Range contains multiple values, a single value or blank

[kyleno]

I have searched for this question but have not found an answer that works for my scenario.

I have range J2:S2 that have flags (I'm just using the letter "x"). I need my formula to tell me if the range contains multiple x's (Multi), a single x (Single) or blank (blank).

I was able to successfully create each formula individually but not one that combines all conditions

=IF(COUNTIF(J630:S630,"x")>2,"Multi")
=IF(COUNTIF(J629:S629,"x")=1,"Single")
=IF(COUNTIF(J628:S628,"x")<1,"(blank)")

I can't seem to figure out the remainder of the nested formula which identifies a single x or blank cell and marks it as such.

I tried this but it doesn't work:
=IF(COUNTIF(J630:S630,"x")>2,"Multi"), IF(COUNTIF(J629:S629,"x")=1,"Single"), IF(COUNTIF(J628:S628,"x")<1,"(blank)"))))))

Please and thank you.

 

[AliGW]

Try this:

=IF(COUNTIF(J630:S630,"x")>1,"Multi",IF(COUNTIF(J630:S630,"x")=1,"Single","Blank")))

 

[kyleno]

Perfect! Thanks!

 

[AliGW]

You're welcome!