How does the hierarchy of if statement work in custom column? help with my code

[yvescn1]

Hi , I have tried doing so nested if else statement in my custom column but it is showing the wrong data based on what i want 

here is my custom column setting

if( [Submitted the current week]="No" and [Active Workstream_AD Build]="Yes") then "Not Submitted" else if([Submitted the current week]="Yes" and [Active Workstream_AD Build]="Yes" and not List.Contains({"Team","End to End"}, [FDS Entity Type])) then if(List.Contains({"NIS", ""}, [Cost Performance Index])) then "Not Submitted" else "Submitted" else if([Submitted the current week]="Yes" and [Active Workstream_AD Build]="Yes" and [Active Workstream AD_Test]="Yes" and not List.Contains({"Team", "End to End"},[FDS Entity Type])) then if(List.Contains({"NIS",""},[Cost Performance Index])) then "Not in Scope" else "Submitted" else "Not in Scope"

here is the data set

I do want to output on the last column "Submitted" since [Submitted the current week]=yes

Active workstream AD_Test, Active Workstream_AD Build = yes

FDS entity type is equal to = Team

i dont understand why it was outputting "Not in Scope"

[wdx223_Daniel · Accepted solution]

each if {[Submitted the current week],[Active workstream AD_Test],[Active Workstream_AD Build],[FDS entity type]}={"Yes","Yes","Yes","Team"} then "Submitted" else "Not in Scope"