Hello,
I'm working on a nested if statement in Excel 2010 that is giving me an error. I'm pasting the code below. The first segment is one I am using currently and it works fine. The 2nd segment is the one returning an error. The only difference is the 2nd one has 1 extra condition added on the end. Both segments are referencing the same Table. I'm sure it is a syntax error, but the parentheses and commas all look correct to me. Much appreciate any assistance!

=IF(OR([@SurveyProcessor]="Miles Farmer", [@SurveyProcessor]="Amy Patterson", [@SurveyProcessor]="Chelsea Largent", [@SurveyProcessor]="Danielle Melick", [@SurveyProcessor]="Julie Lovich", [@SurveyProcessor]="Tonia Bonavito", [@SurveyProcessor]="Shannon Garvey", [@SurveyProcessor]="Jenna Gonzalez"), "Shannon Garvey", IF(OR([@SurveyProcessor]="Mikayla Moten", [@SurveyProcessor]="Breana Davis", [@SurveyProcessor]="Chelsea Liu", [@SurveyProcessor]="Colton Rice", [@SurveyProcessor]="Danielle Gosch", [@SurveyProcessor]="Sam Kincy", [@SurveyProcessor]="Tyler Bailes", [@SurveyProcessor]="James Punches", [@SurveyProcessor]="Brooke Hamel", [@SurveyProcessor]="Sherry Strausbaugh"), "Brooke Hamel", ""))

=IF(OR([@SurveyProcessor]="Miles Farmer", [@SurveyProcessor]="Amy Patterson", [@SurveyProcessor]="Chelsea Largent", [@SurveyProcessor]="Danielle Melick", [@SurveyProcessor]="Julie Lovich", [@SurveyProcessor]="Tonia Bonavito", [@SurveyProcessor]="Shannon Garvey", [@SurveyProcessor]="Jenna Gonzalez"), "Shannon Garvey", IF(OR([@SurveyProcessor]="Mikayla Moten", [@SurveyProcessor]="Breana Davis", [@SurveyProcessor]="Chelsea Liu", [@SurveyProcessor]="Colton Rice", [@SurveyProcessor]="Danielle Gosch", [@SurveyProcessor]="Sam Kincy", [@SurveyProcessor]="Tyler Bailes", [@SurveyProcessor]="James Punches", [@SurveyProcessor]="Brooke Hamel", [@SurveyProcessor]="Sherry Strausbaugh"), "Brooke Hamel", IF([@SurveyLender]="CACU", "Brian Luger),"Client"))