+ Reply to Thread
Results 1 to 7 of 7

IF Statement returns FALSE

  1. 01-26-2011, 02:47 PM #1
    berger01
    berger01 is offline
    Registered User
    Join Date
    01-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2007
    Posts
    76

    IF Statement returns FALSE

    I have this huge IF statement that calculates one way if the Cell is blank and another way if the cell is not blank. I think I'm close but the result returns FALSE. This indicates that the 1st nested statement is working, but has taken precedents over the rest of the formula. Can someone take a look and lend a hand or an eye.... Thanks


    Please Login or Register  to view this content.
    Last edited by berger01; 01-26-2011 at 03:31 PM. Reason: added code tag to contain long formula
    Reply With QuoteRegister To Reply
  2. 01-26-2011, 02:53 PM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: IF Statement returns FALSE

    First of all is F2 blank? If not, then you will get FALSE... you need to add the FALSE condition of "" in order to get a blank back.

    Are the entries in A2 and H2 numeric (based on previous posts you had a problem with this).

    Otherwise post sample workbook, indicating where problem is.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 01-26-2011, 03:03 PM #3
    berger01
    berger01 is offline
    Registered User
    Join Date
    01-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: IF Statement returns FALSE

    Thanks agian NBVC!

    Here is the worksheet. I have not copied down the cell (O2) that I'm working on. Notice Cell F24 (Blank), this situation is what I am trying to compensate for.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-26-2011, 03:09 PM #4
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: IF Statement returns FALSE

    So if F2 is not blank, then what do want returned... is that the part that is not working for you? Are the results (when F2 is blank) otherwise correct?
    Reply With QuoteRegister To Reply
  5. 01-26-2011, 03:14 PM #5
    berger01
    berger01 is offline
    Registered User
    Join Date
    01-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: IF Statement returns FALSE

    If F2 is blank then H2 will be used to calculate the EDATE and return those values. If F2 is not Blank then F2 is used to calculate the EDATE and return those values. Currently only FALSE is returned for all.

    I may have to put the blank arguements as the 2nd in line..... not sure.

    thanks
    Reply With QuoteRegister To Reply
  6. 01-26-2011, 03:17 PM #6
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: IF Statement returns FALSE

    Then perhaps a few closing parenthesis to separate the TRUE and FALSE parts...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-26-2011, 03:31 PM #7
    berger01
    berger01 is offline
    Registered User
    Join Date
    01-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: IF Statement returns FALSE

    That did the trick! You Sir, are incredible.

    Thankyou.
    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)

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