Results 1 to 8 of 8

Why doesnt this nested IF function work? It contains multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2009
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2007
    Posts
    45

    Lightbulb Why doesnt this nested IF function work? It contains multiple criteria

    If anyone could help me with this it would be very much appreciated, I’ve been trying all sorts of combinations with no luck. You will need to look at the picture I've attached to make sense of the below.

    In (C2+) it should display one of the following results - "Listed", "-" meaning not listed, or "Listing Ended". This is worked out from the corresponding dates to the right of "Selling Status" and in (G2) which contains the current date. So when there is nothing entered in (D2) "Selling Status"(C2) should display "-", if a date is entered into (D2) it should then go to "Listed". This part I’ve managed to accomplish, however, when I try add the next part to the equation, it doesn’t seem to like it.

    If "Listing End Date"(E2) is less than the current date(G2), "Selling Status"(C2) should then go to "Listing Ended".

    This is the current formula I have (below) which does actually display "Listing Ended" However it also contains the "Listed" which it should over right.

    Current Formula - =IF((D2=""),"-","Listed"&IF(E2<G2,"Listing Ended",))
    Attached Images Attached Images
    Last edited by RayJay01; 09-06-2009 at 03:24 PM.

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