Parenthesis with complex if statements

[ihateexcel17]

Can someone describe in simple terms the way if statements, and nested if statements, and if(and statements and max(if statements need parenthesis and how they relate to combining them into other formulas?


I currently have a complex index(match formula with multiple criteria that I want to incorporate a max(if into and for the life of me I cannot get past the "your formula is missing some rando parenthsis but haha I'm not going to tell you where it is, b****!".

I am frequently using these long complex formulas and it is a constant battle with figuring out how many parenthesis I need and where they go as there seems to be no rhyme or reason to it.

I know there is a rhyme or reason to it so can someone explain what it is?