Results 1 to 2 of 2

Thread: A mystery...

  1. #1
    Join Date
    May 2004
    Posts
    17

    Unanswered: A mystery...

    Hello,

    We have found a mystery in an Excel-formula : the result displayed on screen is DIFFERENT from the formula result displayed in the formula box, when the formula is edited. The result on screen is FALSE, while the formula result in the "Edit formula" is CORRECT !
    Example :
    These are the formulas and values entered in the cells :

    0,04 0,03 0,05 0,06
    =1+B2 =1+C2 =1+D2 =1+E2
    =PRODUCT(B3:E3)
    =PRODUCT(1+B2:E2)

    On screen :

    4% 3% 5% 6%
    104% 103% 105% 106%
    1,192246
    104%

    The first formula "=PRODUCT(B3:E3)" is OK. The second formula "=PRODUCT(1+B2:E2)" gives a result on screen which is equal to "=PRODUCT(1+B2)" but when clicking on the "=" (Edit Formula) in the formula toolbar, the displayed formula result is OK, equal to (1+4%) *(1+3%) * (1+5%) *(1+6%) = 1,192246.
    This problem doesn't occur when the SUMPRODUCT-function is used on the same data.

    Can anyone explain this mystery to us...

    Many thanks !

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116

Posting Permissions

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