I'm not sure if it can be done, please note I am not a novice, I am trying to join multiple syntax for a calculated column.
I have column 1 as 'state' its values are either California or New York and in Column 2 as 'region' its values are East, West or Special and I need to assign an employee. Employee Jane gets all of California as long as the region is not special and John gets all of New York as long as the region is not special but Joe is assign the special region regardless of state.
My first syntax works great but when I try to join them, it is not being accepted.
Primary Syntax:
=IF(AND([State]="California",[Region]<>"Special"),"Jane","""")
My failed attempt at joining them.
=IF(AND([State]="California",[Region]"Special"),"Jane","""",=IF(AND([State]=
"New York",[Region]"Special"),"John","""",=IF(AND([region]="Special","Joe")))
=
signs, and you've got 4 terms in eachIF
statement, not 3, and your last IF statement just has one boolean term sayingIf Region is Special AND Joe
where I think you wantIf Region is Special, THEN Joe
. I wrote an answer below giving what I think should work for your situation. – KGlasier Dec 6 '18 at 18:38