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:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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
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.
However, it doesn't pick up the "TRUES" in Column T. It will only return "TRUE" if column S has "TRUE" in it.
S 1 Missed a class more than once a month | T Missed a class in consecutive months | U Frequent truant |
2 FALSE | TRUE | NO |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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