How do I fix this error #INCORRECT ARGUMENT SET

=IF([Land Owner/Tenant]@row = "Owner", IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF(OR([Buyout Closing Date]@row <> "", [Vacancy Inspection Date]@row <> ""), MIN(IF([Buyout Closing Date]@row = "", 99999999999999, [Buyout Closing Date]@row), IF([Vacancy Inspection Date]@row = "", 9999999999999, [Vacancy Inspection Date]@row + 365, "")), IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF([Vacancy Inspection Date]@row = "", "", [Vacancy Inspection Date]@row + 365)))))
Thank you.
Best Answer
-
You have an extra component in the second IF() statement within the MIN().
Answers
-
You have an extra component in the second IF() statement within the MIN().
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!