IF, AND, and OR equation
Hello. I am trying to make an IF, AND equation with one of the constituents in the AND equation to have an OR function. The equation would go for the "Amount paid" column. The constituents would be "# of pets", "Talent" and "Time". The "Amount paid" would be $125 if # of pets=1, Talent= External OR Rescue and Time=Half.
Here is what I have: =IF(AND(Talent@row = "External", OR(Talent@row = "Rescue"), [# of pets]@row = 1, Time@row = "Half"), 125)
The equations does not show any errors but does not populate the number.
Best Answer
-
@mpajuelo Try this instead: =IF(AND(AND(OR(Talent@row = "External", Talent@row = "Rescue"), [# of pets]@row = 1), Time@row = "Half"), "125", "")
Answers
-
@mpajuelo Try this instead: =IF(AND(AND(OR(Talent@row = "External", Talent@row = "Rescue"), [# of pets]@row = 1), Time@row = "Half"), "125", "")
-
Works perfectly, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!