Simple Calculation Bug

Discussion in 'Microsoft Excel Discussion' started by Mehmet Esen, Jun 3, 2012.

  1. Mehmet Esen

    Mehmet Esen Guest

    Let's see the table (A1:D11) below:

    A B C D
    1 IN OUT BALANCE
    2 0 0 =+B3-C3
    3 29000 =+D3+B4-C4
    4 13218.78 =+D4+B5-C5
    5 14855.43 =+D5+B6-C6
    6 350 =+D6+B7-C7
    7 575.79 =+D7+B8-C8
    8 =+D8+B9-C9
    9 =+D9+B10-C10
    10
    11 =SUM(B3:B11) =SUM(C3:C11)

    This simple calculation returns the figures such as:

    A B C D
    1 IN OUT BALANCE
    2 - - -
    3 29,000.00 29,000.000000000000000
    4 13,218.78 15,781.220000000000000
    5 14,855.43 925.789999999999000
    6 350.00 575.789999999999000
    7 575.79 (0.000000000000909)
    8 (0.000000000000909)
    9 (0.000000000000909)
    10
    11 29,000.00 29,000.000

    Even if we calculate in a cell : +15781.22 - 14855.43 returns to
    925.78999999999900

    How can I fix this bug?
     
    Mehmet Esen, Jun 3, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. sns

    simple? pasting simple formula, error on copy

    sns, Jan 10, 2004, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    636
    Gord Dibben
    Jan 11, 2004
  2. John

    Simple Formula for simple person. :)

    John, May 5, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    383
  3. Aardvark

    Simple Macro is not so simple

    Aardvark, May 9, 2004, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    440
    Aardvark
    May 9, 2004
  4. Peter McCaul

    #value error for simple calculation

    Peter McCaul, Nov 9, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    389
    JulieD
    Nov 9, 2004
  5. Daywalker

    Probably a simple "IF" calculation, but ???

    Daywalker, Mar 24, 2006, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    279
    Nozza
    Mar 25, 2006
  6. Pedros

    A simple question requiring a simple answer

    Pedros, Jul 18, 2006, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    414
    Paul B
    Jul 18, 2006
  7. Guest

    Excel 2003 calculation bug - subtraction of 1 decimal place

    Guest, Aug 1, 2007, in forum: Microsoft Excel Discussion
    Replies:
    8
    Views:
    634
    Niek Otten
    Oct 6, 2009
Loading...