Embedding IF statements into IF statement

Hey all-

I am working on a sales agreement that outlines the line items and this has worked great.

I also have a formula that states if the Billing State is NC then the customer is taxable. Here it is:

=IF(C10="NC",L33,0)

I also have a cell for tax exempt like this:

Tax Exempt (Y/N): _________ (the blank being the next cell)

Then I have another cell with the total for Taxable Sales like this:

Taxable Sales: ________ (the blank being the next cell)

Currently in the Taxable Sales blank (cell), I have a formula that states:

=IF(C36="Y",0,L33)

Basically if "N" is entered for the Exemption cell then the formula inserts the Total Sales into that cell. If it is "Y" then it inputs $0.00.

What I am trying to do is combine these two. If the customer is in NC and is Tax Exempt then enter $0.00. If they are in NC and are NOT Tax Exempt, then enter the Total Sales.

Please help! I have attached an example.

Thanks,
prefcomm

From your question...Why is it necessary to identify if they are in NC...since you have the tax exempt question that is truly the identify for the Taxable Sales field and you already have it set for that...What if they aren't in NC...does it still matter if they are tax exempt or not?

I guess what Im trying to ask...what if the customer is in OH...could the tax exempt question still matter - or does it only matter with NC?

You make a very valid point. It truly only matters if they are in NC. If they are not in NC then they are exempt anyway.

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


Code:
=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.

You are correct as well - if they are tax exempt then it should be 0.00. Your logic is not backwards at all. LOL This formula worked with one change -

Code:
=if(and(c10="NC",c36="N"),l33,0)

Thanks SO much!!
prefcomm