+ Reply to Thread
Results 1 to 3 of 3

Nesting IF equations - Doesn't recognise final criteria :(

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    29

    Lightbulb Nesting IF equations - Doesn't recognise final criteria :(

    Hi guys,

    I'm pretty new to Excel and pretty lost So hopefully you can help me get around what should be such a simple equation but is resulting in failure

    I have this equation in column K:

    Please Login or Register  to view this content.

    Where:

    A = 1 to 'Infinity' (Currently 1 - 10)
    J = Dates to which the job in that row was 'Closed' (Dates in dd/mm/yyyy format)

    So, I would like K4 to display:

    "" (Nothing) if A4 is less than 0 (Job doesn't exist)
    'Open' if A4 is greater than or equal to 1 (Job exists)
    'Closed' if there is a date in J4 (Job closed)

    However, at the moment, when there is a date in J4, it still returns an answer of 'Open'

    What am I doing wrong
    Last edited by klis; 10-13-2011 at 11:44 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Nesting IF equations - Doesn't recognise final criteria :(

    I think you're evaluating your criteria in the wrong order.

    Each If statement is a Boolean check followed by the action if true then the action if false, so the final IF statement in your formula will only be run if the condition $A4>=1 returns FALSE.

    It sounds like you need to check J4 for a date before you check the value of A4.

  3. #3
    Registered User
    Join Date
    10-13-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Nesting IF equations - Doesn't recognise final criteria :(

    Good lord - You're absolutely right - Gosh, so simple lol

    I didnt realise that the formula worked by order, I just assumed it looked at each criteria individually

    ...Well now I know, I can't thank you enough!

+ 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