IF/OR Formula with multiple criteria not working as desired (365 for enterprise - beginner)

Hey all,

I'm trying to make an IF/OR that will generate a "YES" even if only one of the listed criteria is met.

Originally I was trying:

=IF(OR($B2>6,$C2<80,$D2<3775, $E2="Y"),"NO","YES")

Basically, if absences are greater than 6, Grade is lower than 80, STAAR score is less than 3775, OR Discipline = Y, then the output should be NO, the student is not eligible to exempt.

However what I'm seeing is that nothing is happening unless I enter the STAAR score. Even at zero absences, the data does not change to YES.

SO, I attempted a modified, more specific formula:

=IF(OR($B2>6,$C2<80, $C2>0,$D2<3775, $D2>1649, $E2="Y"),"NO","YES")

Even if I enter data that should result in a YES in the "Eligible?" column, it remains unchanged until I enter the STAAR score.

Other note, I do have conditional formatting on columns B, C, D, and E, but only to change the cell color if certain data are present. For example C2>6 will turn red, C<6, C>2 will turn yellow, and C<3 will turn green.

Please advise! Any help is appreciated.