Results 1 to 5 of 5

excel is adding extra numbers in the 16 decimals when summing

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2019
    Location
    uae
    MS-Off Ver
    ms pro plus 2016
    Posts
    2

    Angry excel is adding extra numbers in the 16 decimals when summing

    i am dealing with excell to check calculation of students and i do all basic calculations and the checks using AND and IF formulas , i discovered many times the logical check of some SUMS were false even it was visible up to 4 decimal points that is correct i wanted to check further so i increased the decimals to 25 and i saw extra numbers are added in the 16decimal digit even if you do the summation with calculator or hand you will not reach this decimal point 16th .... it happens many times with , i hope any one can help , its weired
    as you can see in attachment the circled part in check row is the subraction of the two cells above directly and non of the two numbers have a 16decimal number yet the value in sustraction is showing extra number 9 , also its repeated in the other next columns put with number 45 , and the last column in check row showing false is the result check of the previous numbers are they equal or no and it was false , so from this check i discovered something wrong .
    if any one has similar issue let me know and is there a solution


    excel decimal error.JPG
    Attached Images Attached Images
    Last edited by ashweiki; 10-20-2019 at 05:01 AM. Reason: adding attachment and link

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2014, 04:34 AM
  2. [SOLVED] summing sets of numbers and adding ablank row
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2013, 09:58 AM
  3. Replies: 4
    Last Post: 07-24-2013, 01:43 PM
  4. Replies: 3
    Last Post: 02-09-2013, 01:33 PM
  5. [SOLVED] adding decimals or periods to a string of numbers
    By jimmyhamic in forum Excel General
    Replies: 15
    Last Post: 07-27-2012, 07:15 AM
  6. extra hours adding money for each extra hour worked FORMULA
    By cynthiamcastro in forum Excel General
    Replies: 3
    Last Post: 06-18-2012, 11:27 AM
  7. Conversion of days into numbers and adding extra columns
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2011, 10:07 AM
  8. Summing large numbers with decimals in Excel
    By PradeepKel in forum Excel General
    Replies: 1
    Last Post: 06-05-2006, 11:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1