How to run one formula or another
Hello...
How would I write the following formula where it is either the first one or the second one? Right now, it seems to work, but I can see the potential for error with using the + sign. I just want it to run one formula if the conditions are met or the other if the conditions are met. If neither conditions are met, then I want the cell to be blank. I tried unsuccessfully to incorporate OR in the formula. Hoping someone else might know. Thanks in advance!
=IFERROR(IF([PCD Status Draft 1]@row = "In process", NETWORKDAYS([PCD Draft 1 Start Date]@row, TODAY(0), {Holidays})), "") + IFERROR(IF([PCD Status Draft 1]@row = "Sent to SME", NETWORKDAYS([PCD Draft 1 Start Date]@row, [SME Draft 1 Review Start Date]@row, {Holidays})) - 1, "")
Answers
-
I would suggest wrinting it asw a nested IF instead.
=IFERROR(IF([PCD Status Draft 1]@row = "In process", first_formula, IF([PCD Status Draft 1]@row = "Sent to SME", second_formula)), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!