I don't understand why my formula won't work?

[Holly92]

Hi! If anyone could help with this, that would be very very helpful!

I am trying to identify in Cell U2, people who either missed a class many times in once month, or consecutively missed classes in the following months. So I would like Cell U2 to say "TRUE" if either S1 or T1 say "TRUE". I have inputted the following formula:

=IF(OR(S2="TRUE",T2="TRUE"),"YES","NO")

However, it doesn't pick up the "TRUES" in Column T. It will only return "TRUE" if column S has "TRUE" in it.
​

[TABLE="width: 330"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] S
1 Missed a class more than once a month[/TD]
[TD]T
Missed a class in consecutive months[/TD]
[TD]U
Frequent truant[/TD]
[/TR]
[TR]
[TD]2 FALSE[/TD]
[TD]TRUE[/TD]
[TD]NO
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Would anyone be able to offer advice on how to tweek this formula so that is returns "TRUE" in Cell U2, as long as there is a "TRUE" in either the S or T column?

Thank you in advance!

Best wishes,

Holly

 

[MARK858]

What happens with

=IF(OR(TRIM(S2)="TRUE",TRIM(T2)="TRUE"),"YES","NO")

 

[PureBluff]

You don't want the if's logical test to be against a string value.

=IF(OR(S2="X",T2="X")=TRUE,"Yes","No")

 

[Dave Patton]

Excel 2010
	R	S	T
2	TRUE	TRUE	TRUE
3	YES
4
2e

Cell Formulas
Range	Formula
R2	=OR(S2=TRUE,T2=TRUE)
R3	=IF(OR(S2=TRUE,T2=TRUE),"YES","NO")

True is a logical result not Text.

 

[Chrisdontm]

It looks like it is right...

I tried something that made it work.

I took away the quotes in the OR function.

It doesn't seem like that would matter, but, it worked now...

=IF(OR(S2=TRUE,T2=TRUE),"YES","NO")

 

[Holly92]

Ah thank you very much! This has worked, and I now know about TRIM!

 

[Holly92]

Ah of course, TRUE is not text! I would have bene stuck on this forever. Thank you very much!