Why will my And/Or statement not work

[nickrosen28]

Hi everyone,

I have an and or statement that looks at one column, and then once it spots "flagship" it look for any of the following "or's"

I am at a loss trying to get it to work.

Any help would be appreciated(:

[nickrosen28]

Finally works thanks!

But, I need the formula to be "doing" this:

If Lounge type says "Flagship"

And one of the following or is not met put an "x".

Im getting the "x" on every row.

[alexnajm]

Try out the edited second formula!

[nickrosen28]

Appreciate the help!

WIll tinker with it.

Thanks again

[alexnajm]

Happy to help! When you resolve it, please accept one or more of the responses as a solution so the thread closes 😊