IF with AND and OR statement

I know this has been discussed before and I've read several posts but I'm still having some trouble and I'm sure it's really easy for the experienced folks here. Referencing the diagram I am trying to turn the star column on with the following logic:
If % Complete = 100% AND RA Status = "A" or "B" then turn star on.
I've got the AND working and OR working separately but get error when trying to combine.
Works for 1 item in RA Status (no OR) =IF(AND([% Complete]@row = "1", [RA Status]@row = "A"), true)
Works for the OR =IF(OR([RA Status]@row = "A", [RA Status]@row = "B")
How do I set it up to combine the 100% complete AND RA Status "A" OR "B"
Thanks!
@Hollie Green maybe?
Best Answer
-
=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
Answers
-
=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
-
@Hollie Green I was so close. You are the best - I owe you - thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives