Tags: a110, a2-a1, a210, calculates, cell, excel, formula, microsoft, miscalc, msdn, software

excel miscalc?

On Microsoft » Microsoft Excel

818 words with 1 Comments; publish: Wed, 04 Jun 2008 12:03:00 GMT; (30662.50, « »)

if cell A1=10.1, and cell A2=10, then the formula A2-A1=.1

should be TRUE, but excel calculates this to

be .9999999999999430, Why is this'

All Comments

Leave a comment...

  • 1 Comments
    • See

      http://www.cpearson.com/excel/rounding.htm

      and

      http://www.mcgimpsey.com/excel/pennyoff.html

      --

      For everyone's benefit keep the discussion in the newsgroup.

      Regards,

      Peo Sjoblom

      "estimated" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:1770501c4497a$756a8750$a601280a.excel.todaysummary.com.phx.gbl...

      > if cell A1=10.1, and cell A2=10, then the formula A2-A1=.1

      > should be TRUE, but excel calculates this to

      > be .9999999999999430, Why is this'

      #1; Wed, 04 Jun 2008 12:04:00 GMT