A formula for text

[Xzebetz]

Hi,
I have been trying to solve a problem. I'll try to explain by example:

I have a sheet where:

Cells F5:Q5 can contain several text info. They can either contain offline, online, error. I need to return an output in call E5 based on what F5:Q5 contains.

So, if:
All cells contain online, then return online
All cell contain offline, then return offline

But here is the tricky part:

If not all cells contain online, then return X (12 cells, if 11 or more contain any other text than online, return an other value then online).

Hope it makes sense.

Thank you.

 

[Special-K99]

=IF(COUNTIF(F5:Q5,"Online")=12,"Online",IF(COUNTIF(F5:Q5,"Offline")=12,"Offline","X"))

If all cells in the range F5:Q5 equal Online, then return Online
If all cells in the range F5:Q5 equal Offline, then return Offline
otherwise return X