TwinJohnson
New Member
- Joined
- Jul 15, 2021
- Messages
- 11
- Office Version
- 365
- 2011
- Platform
- Windows
There are four possible outcomes
If cell A2 contains no date the expected status is "No Entry Sent"
If cell A2 contains a date <= today then the expected status is "Entry Sent"
If cell A2 contains a date <=today and cell B2 contains a date <=today then the expected status is "Released Not Delivered"
If cell A2 contains a date <=today and cell B2 contains a date <=today and cell C2 contains a date <=today then the expected status is "Delivered", if C2 is blank then "Released not Delivered"
The formula should check all three columns that are in the order in which data is expected to flow as illustrated.
I've tried so many different formulas starting off with writing them separately and piecing them together and run into I can use multiple if's with multiple true's but only one false.
Thank you!
If cell A2 contains no date the expected status is "No Entry Sent"
If cell A2 contains a date <= today then the expected status is "Entry Sent"
If cell A2 contains a date <=today and cell B2 contains a date <=today then the expected status is "Released Not Delivered"
If cell A2 contains a date <=today and cell B2 contains a date <=today and cell C2 contains a date <=today then the expected status is "Delivered", if C2 is blank then "Released not Delivered"
The formula should check all three columns that are in the order in which data is expected to flow as illustrated.
I've tried so many different formulas starting off with writing them separately and piecing them together and run into I can use multiple if's with multiple true's but only one false.
Thank you!