+ Reply to Thread
Results 1 to 3 of 3

Precision error while adding or subtracting values in excel.

Hybrid View

alokmpatel Precision error while adding... 11-19-2015, 04:13 AM
Glenn Kennedy Re: Precision error while... 11-19-2015, 04:25 AM
alokmpatel Re: Precision error while... 11-19-2015, 06:38 AM
  1. 11-19-2015, 04:13 AM #1
    alokmpatel is offline
    Registered User
    Join Date
    08-19-2013
    Location
    vadodara
    MS-Off Ver
    Excel 2007
    Posts
    2

    Angry Precision error while adding or subtracting values in excel.

    Hello Every one,
    i have found some strange error while adding or subtracting the fraction values.

    Formulae in cells.
    formula.GIF

    results of above formulae
    values.GIF

    if i am doing 1-1/3-2/3 it is giving correct value.
    but if i am doing 1-1/3-2/3-0 the result is strange.

    Please help.

    Alok.
    Reply With QuoteRegister To Reply
  2. 11-19-2015, 04:25 AM #2
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Precision error while adding or subtracting values in excel.

    Simple answer: computers can't count...

    Longer answer:

    https://support.microsoft.com/en-gb/kb/78113
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 11-19-2015, 06:38 AM #3
    alokmpatel is offline
    Registered User
    Join Date
    08-19-2013
    Location
    vadodara
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Re: Precision error while adding or subtracting values in excel.

    I got your point.

    Thanks for Quick reply.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting paramater values to excel retaining precision of number
    By angusmdmclean in forum Excel General
    Replies: 6
    Last Post: 11-15-2015, 08:57 PM
  2. Changing Zero values and adding or subtracting small amounts from values in other cells
    By Rcollie in forum Excel General
    Replies: 2
    Last Post: 09-06-2015, 12:03 AM
  3. Calendar Scheduling and Adding/Subtracting non-numeric values
    By jmullini in forum Excel General
    Replies: 0
    Last Post: 02-14-2015, 09:52 AM
  4. Excel 2008 : Adding/Subtracting/etc money values that are split into £ and p columns
    By dancing-shadow in forum Excel General
    Replies: 3
    Last Post: 01-19-2012, 07:02 PM
  5. Excel 2007 : Adding AND subtracting time in Excel 2007
    By CLUPICO in forum Excel General
    Replies: 2
    Last Post: 09-19-2009, 11:11 AM
  6. Rounding Error when adding or subtracting two cells
    By mtheo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 02:55 PM
  7. Precision displayed does not match precision in cell
    By James Wilkerson in forum Excel General
    Replies: 10
    Last Post: 06-15-2005, 10:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1