If/And Statement

Kyle Hicks

Hey again,

I am stuck with something a bit beyond my current skills.

I need to write a formula that I believe will be an If/And Formula.

The formula needs to populate the Case Status cell.

If the the Tentative Return Date column is blank, the Case Status Cell should be "N/A", if the Tentative Return Date is within 10 Days Case Status should be "Active Case" and if Tentative Return Date has more than 10 days passed since the submission it should read "Past 10 Days."

Jeff Reisman

@Kyle Hicks

You should be able to use the "Change a Cell Value" automation to do this, rather than a convoluted formula of nested IF functions.