+ Reply to Thread
Results 1 to 6 of 6

Multiplication Bug - Excel (Office) 2010

  1. #1
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Multiplication Bug - Excel (Office) 2010

    I have been running this exercise in Excel on my computer, and getting erroneous results (as is Excel, on a friend’s computer).

    http://raivynnsroost.blogspot.com.au...y-day-for.html


    My formula is “0.01” in A1 and “=(A1*2)” in A2 (without the quotes).

    I then dragged A2 down the column, as far as I like…

    I have formatted the spreadsheet as shown on page 1 of the attachment, and the error is on page 2 (it starts on row 51, among the cents).

    Both computers are running:

    Office Home & Student 2010
    Windows 7 64-bit (SP1)


    Mick
    Attached Files Attached Files
    Last edited by mgs; 05-05-2014 at 03:06 AM.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Multiplication Bug - Excel (Office) 2010

    Hello mgs,

    I cannot determine what your problem is by looking at a picture. Please could you upload a sample Workbook for us to have a look at.?

    Thank you.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Multiplication Bug - Excel (Office) 2010

    Hi Winon,

    Here is the sample file.

    Mick
    Attached Files Attached Files
    Last edited by mgs; 05-05-2014 at 03:20 AM.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Multiplication Bug - Excel (Office) 2010

    Hello mgs,

    Thank you.

    Now this is very interesting, and something I did not know, until now.

    Have a look at this site, where Excel limitations are discussed.

    Excel truncates your numbers to 15 significant digits. For example, if you enter this number in Excel:

    123456789123456789

    Excel truncates it to this. Notice that Excel doesn't even round it correctly; instead it just replaces all digits after the 15th digit with zeros:

    123456789123456000

    http://precisioncalc.com/What_is_xlPrecision.html

    Best regards.

  5. #5
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Multiplication Bug - Excel (Office) 2010

    Thanks Winon, I appreciate your attention.

    Cheers,
    Mick

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Multiplication Bug - Excel (Office) 2010

    You are welcome Mick!

    'Till later.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to a Cashier Program in MS Office excel 2010?
    By regieb24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2014, 05:36 AM
  2. Workbook VBA Project Reference will not migrate form Office 2010 to Office 2002
    By DAve Bradbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 07:43 AM
  3. [SOLVED] Sorting Macro From Office 2010 In Office 2003
    By splendidus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2012, 04:55 AM
  4. [SOLVED] Help! Switch from Office 2007 to Office 2010
    By Khristine L in forum Excel General
    Replies: 2
    Last Post: 05-28-2012, 08:37 AM
  5. Opening excel in office 2010 and not office "starter"
    By AlisonK in forum Excel General
    Replies: 3
    Last Post: 03-02-2012, 10:01 AM

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