Hi,
I just can't get a nested IF statement to work with 3 conditions and outcomes. Not sure where I'm going wrong.
I need the formula in column D to look at a date, (cell A2) and base the outcomes on one of these 3 conditions:
If the date in cell K5 is before what's in A2 = Expired
If the date in cell K5 is after what's in A2 = Live
If there is nothing in cell K5 = Pending
It needs to copy down the column too.
I've attached a sample workbook for reference with examples of the 3 conditions and outcomes.
I'm not sure if it's the dates or the blank cell that's causing me the trouble so any help is greatly appreciated.
Thanks very much,
Lindsey
Bookmarks