=IF(OR, how many (OR's?
I currently have an =IF(OR formula that works well. Now I need to expand the entries it looks for in the given cell to include two more criteria. As it works:
=IF(OR($[Employee/Contractor]@row = "John Doe", $[Employee/Contractor]@row = "Jane Doe"), $[Time - Rounded]@row, $[Time Worked = Bill Rate]@row)
How I now need to expand it:
=IF(OR($[Employee/Contractor]@row = "John Doe", $[Employee/Contractor]@row = "Jane Doe", $[Employee/Contractor]@row = "Piglet", $[Employee/Contractor@row = "Pooh"), $[Time - Rounded]@row, $[Time Worked = Bill Rate]@row)
Should it now begin and end: =IF(OR(OR(OR($[Employee/Contractor]@row = blah, blah, blah $[Time Worked = Bill Rate]@row)))
Or is adding more (OR statement not possible? I keep getting UNPARSEABLE and INCORRECT ARGUMENT SET errors
Thank you. Jerry
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!