Nested IF statement giving INCORRECT ARGUEMENT SET
Based on Fund Type, need to return PO #. Using a nested IF with the Second IF called as part of the FALSE condition of the First IF. I added a second FASLE condition (the 1)to force a False value but not succesful with getting rid of the INCORRECT ARGUEMENT SET.
I think, I'm lost in parens....
=IF([Fund Type]@row = "O&M", INDEX(COLLECT({'PO #'}, {'Fiscal Year'}, [Fiscal Year]@row, {'Vendor'}, Vendor@row, {'Fund Type'}, [Fund Type]@row)), (IF([Fund Type]@row = "CIP", INDEX(COLLECT({'PO #'}, {'Vendor'}, Vendor@row, {'Fund Type'}, [Fund Type]@row)), 1)))
Answers
-
I found the offending paren.
Correct solution:
=IF([Fund Type]@row = "O&M", INDEX(COLLECT({'PO #'}, {'Fiscal Year'}, [Fiscal Year]@row, {'Vendor'}, Vendor@row, {'Fund Type'}, [Fund Type]@row), 1), IF([Fund Type]@row = "CIP", INDEX(COLLECT({'PO #'}, {'Vendor'}, Vendor@row, {'Fund Type'}, [Fund Type]@row), 1), 1)
-
Hi @Tnorman
Thanks for posting your solution! I'm glad you figured it out. 🙂
Need more information? 👀 | 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
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!