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
(thinking…)
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
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base