Nested IF statement giving INCORRECT ARGUEMENT SET

Tnorman

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)))

Tnorman

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)

Genevieve P.

Hi @Tnorman

Thanks for posting your solution! I'm glad you figured it out. 🙂