I'm trying to write an IF statement with an OR, so that if what's in C2-7 starts with a 5 or a 2 it brings back a "Correct". If it doesn't start with either of those, then I want it to be blank.
I wrote the below and I can't figure out why it's not working.
=IF(OR(RIGHT(A3,1)="2",RIGHT(A3,1)="5"),"Correct","")
I've attached the worksheet - I feel like I'm missing something obvious.
Bookmarks