If/And Formula Question

Options

I need to write a formula that allows me to dictate that two conditions on a single cell are met and one condition on an additional cell is met. The formula will be if the start date is not blank and is less than today and the status column is blank then the flag is checked. I am unsure as to how to write the syntax for multiple conditions in the same cell. See screenshot.


Answers

  • Matthew Flebbe
    Matthew Flebbe ✭✭✭✭
    Options

    Hi Angie,

    If I understand correctly, you will also need to incorporate an OR function since you need the flag if the "Start Date" column is blank OR less than today AND the "Status" column is blank.

    You can do this with the following formula:

    =IF(AND(OR(Start@row < TODAY(), Start@row = ""), Status@row = ""), 1, 0)

    I hope that helps. Please let me know if you have any additional questions.

    best,

    Matt

  • Angie Druley
    Options

    Thanks, Matt, I appreciate it. It took awhile, but I was able to work it out with the following formula:

    I actually need the flag NOT to check if the date is blank.