Two IF functions for one cell


Need to do the following:

If Cell B has a date within the next 30 days, Cell A will output CHECK QUOTE VALIDITY. But, if Cell C is checked, leave Cell A blank.

I have the following formula already in Cell A. What should I add to have the above?

=IF(AND([Quote Validity]69 >= TODAY(), [Quote Validity]69 <= TODAY(30)), "CHECK QUOTE VALIDITY", "")


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Screenshots make it so much easier.

    =IF(OR([Quote Validity]@row ="", [No Need to Maintain Quote Validity]@row=1), "", IF(AND([Quote Validity]@row >= TODAY(), [Quote Validity]@row <= TODAY(30)), "CHECK QUOTE VALIDITY"))