Double IF with OR Formula leaving cell blank

[drop05]

Hello I have this formula I am trying to get to work and it is leaving the cell place when I have an X in T5 and the word First Class is on b33 on the page this page
I was wondering what I am doing wrong? I am trying to do is if First class is on cell b33 on page This Page then do the following If statement IF(OR($T5="X",$U5="X",$V5="X",$W5="X",$X5="X"),"X","") can take place where if any of those columns on row 5 have an X then it is good to put an X, just the looking for First Class has to happen first and if it is not first class then it does nothing basically
=IF(ThisPage!$B$33="First Class",IF(OR($T5="X",$U5="X",$V5="X",$W5="X",$X5="X"),"X",""),"")

 

[jtakw]

Hi,

I don't see an issue with your formula, if you're not getting the correct result, perhaps check your B33, T5, U5, etc. for leading and/or trailing spaces ?

 

[Peter_SSs]

What is the name of the sheet that the T5 to X5 in your formula are on?
What is the name of the sheet that the formula is on?

I agree with @jtakw about your current formula, but note that it could also be written as

=IF(AND(ThisPage!$B$33="First Class",COUNTIF(T5:X5,"X")),"X","")

 

[drop05]

Hi,

I don't see an issue with your formula, if you're not getting the correct result, perhaps check your B33, T5, U5, etc. for leading and/or trailing spaces ?

It was a simple mistake, it was because of the "" since it was an integer, i got rid of them and it fixed it! Thank you

 

[drop05]

What is the name of the sheet that the T5 to X5 in your formula are on?
What is the name of the sheet that the formula is on?

I agree with @jtakw about your current formula, but note that it could also be written as

=IF(AND(ThisPage!$B$33="First Class",COUNTIF(T5:X5,"X")),"X","")

I like this formula! I make it noted but yeah I just mentioned that because of the "" it was not doing it so got rid of them and it worked!
Thank you as well for your comment and help!

 

[jtakw]

You're welcome, glad you got it working.