Tolerance Formula based on Different Levels - Nested If?

[dminar11]

I'm working on updating a spreadsheet that calculates whether or not a project is within tolerance or above or below a tolerance level based on the value of the project and then a corresponding formula.

The formulas as written (see tolerances tab) work but the data is not static and the project values can change and hence the tolerance formula needs to update.

I guess I can try to do a nested IF formula but I'm really bad with the paranthesees and seem like I can never get them right.

Any suggestions? (formulas and data attached hopefully )