I have a problem with a large excel file where I am doing an if statement like

=IF(B2=C2, "Pass", "FAIL")

Both B2 and C2 appear to have the same values but excel returns FAIL. I can fix this, but it is very manual. Excel recognizes the values as equal after I click in cell B2 and press enter. I am trying to figure out a way to do this for thousands of records without having to click in each cell and press enter. Any advice?

Thanks