IF OR Formula...HELP

Suzanne P
✭✭
I am having trouble creating an IF OR formula in a check box. I would like the box to be checked if the value in one column (drop down box column) = Complete or Not Needed. So far I have:
=IF(OR([Status]4 = "Complete", [Status]4 = "Not Needed", "1,0"))
I am getting an "incorrect argument set" error
Comments
-
YIPPEEE.....I figured it out...
=IF(OR(Status4 = "Complete", Status4 = "Not Needed"), 1, 0)
-
Great Job!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 451 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives