Embedding IF statements into IF statement

This is what you are asking for...but if the customer is NOT in NC...it won't matter what the tax exempt indicator is....

If BOTH criteria (NC and TAX EXEMPT) are true...then = L33 otherwise 0.00

=if(and(c10="NC",c36="Y"),l33,0)

Although...I would think that if they are tax exempt...then it should be 0.00 instead of putting in a taxable sales amount...but my logic may be backwards...in anycase...your are wanting to look at an IF statement combined with an AND statement.