Feedback by UserVoice

How can we improve Excel for Mac?

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?

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gary Vasas shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base