=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
-
This content has been removed.
-
Hi @jb@59069
You're correct, there don't need to be any additional OR functions added. I'm glad you got it working!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!