Why do I get unexpected results when executing a formula?

Make sure none of the columns referenced by the formula are formatted as Text. If you are experiencing round-off errors, you should use the Double format instead of Float.