Can I put these three formulas together?

[suzette0735]

I have tried putting these three formulas together in one cell but keep getting errors: Can anyone help?
=IF(AND($I$9="TAX",K14="Y"),(((((M14*$I$8)+M14)*0.0825)+M14*$I$8)+M14),0)
=IF(AND($I$9="TAX MATERIALS ONLY",K14="N"),((M14*$I$8)+M14),0)
=IF($I$9="TAX EXEMPT",((N14*$I$8)+N14),0)
I am trying to get the retail amount in a certain cell with tax or with out depending on the type of construction type and whether they are tax exempt tax or tax on materials. I get it to work in three separate cells but cannot combine.
Thanks!

 

[Fluff]

How about

=IF(AND($I$9="TAX",K14="Y"),((((M14*$I$8)+M14)*0.0825)+M14*$I$8)+M14,IF(AND($I$9="TAX MATERIALS ONLY",K14="N"),(M14*$I$8)+M14,IF($I$9="TAX EXEMPT",(N14*$I$8)+N14,0)))

 

[suzette0735]

How about

=IF(AND($I$9="TAX",K14="Y"),((((M14*$I$8)+M14)*0.0825)+M14*$I$8)+M14,IF(AND($I$9="TAX MATERIALS ONLY",K14="N"),(M14*$I$8)+M14,IF($I$9="TAX EXEMPT",(N14*$I$8)+N14,0)))

Thank you so much it seems to be working but i keep getting a circular reference error.

 

[Fluff]

What cell do you have the formula in?

 

[suzette0735]

What cell do you have the formula in?

n14

 

[Fluff]

That's why you get a circular reference as the formula is looking at itself.

 

[suzette0735]

That's why you get a circular reference as the formula is looking at itself.

omgosh! I see it now and adjusted! Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.