Help with an IF/AND/OR formula

Jenna Corso

Hello,

I am trying to write a formula to return today's date when all of the following are met:

Column 1 is not blank

Column 2 is not blank

Column 3 is either Kangaroo or Platypus

If any of these is untrue, then I would like the cell to remain blank.

Here is my attempt which returns an incorrect argument error:

IF(AND([Column 1]1 <>"", [Column 2]1 <>"", OR([Column 3]1 = "Kangaroo", [Column 3]1 = "Platypus"), TODAY(), "")

What am I doing wrong? 🤔

Paul Newcome

You just forgot to close your AND statement.

=IF(AND([Column 1]1 <>"", [Column 2]1 <>"", OR([Column 3]1 = "Kangaroo", [Column 3]1 = "Platypus")), TODAY(), "")

Paul Newcome

You just forgot to close your AND statement.

=IF(AND([Column 1]1 <>"", [Column 2]1 <>"", OR([Column 3]1 = "Kangaroo", [Column 3]1 = "Platypus")), TODAY(), "")

Jenna Corso

You are correct! Thank you very much!!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate answer as "helpful" so that others know a solution has been found.