If Nested Statements
Please review and let me know where I am missing the formula. We have a column named Locations and next is the Campus. There are six possibilities and then everything else is Fort Worth Campus.
I have tried using the @row and did not like that either.
This formula is in the campus column.
=IF([Location]1="Kansas City CORP 4501","Kansas City",
IF([Location]1="Kansas City CORP 4515",Kansas City",
IF([Location]1="California Division Office","SanB Campus",
IF([Location]1="Topeka - COB","Topeka Campus",
IF([Location]1="Topeka - GOB","Topeka Campus",
IF([Location]1="Topeka 4th Street Warehouse","Topeka Campus","Fort Worth Campus"))))))
Any help would be great...
Thanks
Best Answer
-
@Mark Data Man your second IF statement is missing the opening quotation marks around Kansas City.
Answers
-
@Mark Data Man your second IF statement is missing the opening quotation marks around Kansas City.
-
Awesome thank you,
Sometime after working in so much detail I miss the trees in the forest.
Works
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!