If Nested Statements

Mark Data Man

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

Lucas Rayala

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

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