Results 1 to 4 of 4

Extremely Weird Math Bug !! Formula is correct, but Excel aggregates wrong!!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-10-2018
    Location
    Calgary, Canada
    MS-Off Ver
    2016
    Posts
    214

    Extremely Weird Math Bug !! Formula is correct, but Excel aggregates wrong!!

    Please see attached spreadsheet, showing the mathematical error. You'll see in Column B is a repeating formula that calculates an integer number that changes every 14 days on a Tuesday.

    The problem is in line 47, where suddenly thereafter it changes the integer number every Monday!!

    If you dissect the formula:

    =IF(ABS(B46-TRUNC(B46)) + ((A47-A46)*0.01) > 0.01*$C$4, TRUNC(B46)+1.01, B46 + ((A47-A46)*0.01))

    The blue formula calculates as FALSE, and yet the TRUE part of the IF statement (red) is executed!!!

    Does anyone know why? Thanks!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 02-21-2019, 10:42 AM
  2. [SOLVED] Weird Excel Math
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-30-2015, 07:55 AM
  3. Replies: 3
    Last Post: 10-10-2014, 08:14 AM
  4. [SOLVED] Area between weird curves made out of lines (math problem?)
    By dejhantulip in forum Excel General
    Replies: 4
    Last Post: 04-04-2012, 07:07 PM
  5. Fill down produces correct formula but wrong answer
    By Jim at SDSU in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2006, 03:10 PM
  6. Replies: 3
    Last Post: 02-16-2006, 07:00 AM
  7. Formula correct, answer wrong
    By TJAC in forum Excel General
    Replies: 2
    Last Post: 01-03-2006, 02:20 PM

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