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

Find more posts tagged with

Accepted answers

Lucas Rayala

@Mark Data Man your second IF statement is missing the opening quotation marks around Kansas City.

All comments

Lucas Rayala

@Mark Data Man your second IF statement is missing the opening quotation marks around Kansas City.

Mark Data Man

Awesome thank you,

Sometime after working in so much detail I miss the trees in the forest.

Works

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.