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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sns

    simple? pasting simple formula, error on copy

    sns, Jan 10, 2004, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    456
    Gord Dibben
    Jan 11, 2004
  2. Peter McCaul

    #value error for simple calculation

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

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

    Daywalker, Mar 24, 2006, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    159
    Nozza
    Mar 25, 2006
  4. Guest

    Excel 2003 calculation bug - subtraction of 1 decimal place

    Guest, Aug 1, 2007, in forum: Microsoft Excel Discussion
    Replies:
    8
    Views:
    515
    Niek Otten
    Oct 6, 2009
  5. T. Valko

    Excel 2007 calculation bug fix

    T. Valko, Oct 10, 2007, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    145
    T. Valko
    Oct 10, 2007
Loading...

Share This Page