I'm trying to make a function that says IF B7 = $B$7, $B$8, $B$10 then TRUE value equals "Correct".
The reason I didn't make an absolute reference to the first B7 is so that I can autofill, and therefore those values can change.
Ex: B7 = $B$7, $B$8, $B$10
B8 = $B$7, $B$8, $B$10
B9 = $B$7, $B$8, $B$10 ---> This one would be false
However when I do this with the OR function, it ends up not working. Here is what I have so far: =IF(OR(B7=$B$7,$B$9,$B$10),"Correct")
Thanks
Bookmarks