Strange Excel bug I encountered, curious for an explanation.
so try this out. in one cell do 13/6 in another do 7/6. you'll get 2.166666667 and 1.166666667. Subtract 2 from the cell with 2.166666667 and 1 from the 1.166666667. You now have 2 cells with .166666667. Do an if statement on them to ensure they're the same. now take both cells and multiply them by 6. Both cells should contain 1. Do another If statement......They're different now right? Blow out the decimal places so it goes about 10 decimals deep and one changes to .9999999999990 while the other remains 1.....weird right?