I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be "if this, then that or if this, then that". What I need is: "If this is equal to this, and this is equal to this, then this"
Here is what I have come up with:
=IF(AND(Firm2 = {Building Code}, Firm = {Firm},), {Encumbrance},0)
What I am trying to accomplish is if a two criteria are met, then the encumbered amount is brought over to this sheet.