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",))![]()
Bookmarks