Excel If Or Statement not working

Question

I have two columns of data and I wanted to identify the swap candidate based on two criteria:

1. If first column < 0.5 OR
2. If first column divided by second column < 10.

And here's my formula =IF(OR(E2<0.5,(E2/F2)<=10),"Swap Candidate"," ")

(The first and second column are in column E and F in the workbook). But the function doesn't work as it should. It instead returns all values as true while it's not. For example in the highlighted cell.

I also ran the formula evaluate for the highlighted cell. And it shows FALSE after evaluating the OR statement but then return the value if true.

The numbers are stored in the correct format. So I don't get what's going on with it. Could anyone help me out please?

Answer 1

Check if your workbook are calculating, press F9 to force you workbook to calculate

Edit 1:

I tried input your formula in my Excel(PT-BR) and works, look:

Edit 2:

See if your workbook aren't calculating, click in "Formulas" and check if "Calculate Options" are "Manual" or "Automatic Except for Daata Tables", if one of options are checked, change to "Automatic"