It's evaluating correctly, just not calculating correctly.

I believe everything is a floating point calc to excel, so errors creep in. See the attached. I changed nothing but the format of the cell.