+ Reply to Thread
Results 1 to 2 of 2

IF formula reference error

  1. #1
    Micayla Bergen
    Guest

    IF formula reference error

    So =IF(U4="","",IF(U4<'MDA Portfolio Summary'!H8,"ACQUIRE",IF(U4>'MDA
    Portfolio Summary'!J8,"REDUCE",""))) was working, but now i get a REF error.
    the values in H8 and J8 are percentages, and U4 is also a formula result as a
    percentage. is this why i get a ref error, i cant find anything else wrong


  2. #2
    Max
    Guest

    Re: IF formula reference error

    Resolved in earlier thread:
    http://tinyurl.com/b7wzk
    (culprit was a line-break in the pasted formula)
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Micayla Bergen" <[email protected]> wrote in message
    news:[email protected]...
    > So =IF(U4="","",IF(U4<'MDA Portfolio Summary'!H8,"ACQUIRE",IF(U4>'MDA
    > Portfolio Summary'!J8,"REDUCE",""))) was working, but now i get a REF

    error.
    > the values in H8 and J8 are percentages, and U4 is also a formula result

    as a
    > percentage. is this why i get a ref error, i cant find anything else wrong
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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