Help with an IF/AND/OR formula
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? 🤔
Best Answer
-
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(), "")
Answers
-
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(), "")
-
You are correct! Thank you very much!!
-
Happy to help! 👍️
Please don't forget to mark the most appropriate answer as "helpful" so that others know a solution has been found.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!