+ Reply to Thread
Results 1 to 9 of 9

Extra Pair of Brackets gives different result

Hybrid View

  1. #1
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Extra Pair of Brackets gives different result

    I see it now..

    Pretty sure it's related to the Floating Point Precision issue (google it)
    Basically not all decimal values can be stored precisely in a binary system
    The result you see in T41 is a miniscule value less than absolute 0, shown in Scientific notation.
    A further calculation of =T41+1 results in 1.

    I think the extra () creates an additional calculation step, revealling the FPP issue.
    Last edited by Jonmo1; 06-13-2016 at 10:08 AM.

+ 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. [SOLVED] Macro to set extra extra thick outer border for selected column and row:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2014, 01:43 PM
  2. [SOLVED] Automating Brackets, and Sum above Brackets in Excel Chart
    By cartica in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-24-2014, 11:33 AM
  3. [SOLVED] SUM(COUNTIF.. with more than one pair of curly brackets ?
    By Gabor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2013, 03:46 PM
  4. [SOLVED] Having a problem with VLOOKUP and need an extra pair of eyes.
    By poisontoast in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2012, 06:28 AM
  5. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  6. Replies: 3
    Last Post: 07-20-2012, 07:29 PM
  7. Replies: 5
    Last Post: 04-19-2012, 09:02 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