Nested IF + AND IF statements - Help!

Hi Guys

I'm building a sales commsion 'tracker' and I think I'm almost there but the last step has stumped me. I'm trying to create a formula that says:

If the Revenue Type = Multiyear, multiply the Quota Value by 2%.
If the Revenue Type = Hardware, multiply the Quota Value by 3%.
If the Revenue Type = Licence, AND the Total Licence Quota equal to or less than 90,000, multiply the Quota Value by 4%.
If the Revenue Type = Licence, AND the Total Licence Quota equal to or less than 180,000, multiply the Quota Value by 5%.
If the Revenue Type = Licence, AND the Total Licence Quota equal to or less than 270,000, multiply the Quota Value by 6%.
If the Revenue Type = Licence, AND the Total Licence Quota greater than 270,001, multiply the Quota Value by 12%.

Here is my attempted formula below;

=IF(D9="Multiyear",J9*0.02,IF(D9="Hardware",J9*0.03,IF(AND(D9="License",Total_Licence_Quota<="90,000"),J9*0.04,IF(AND(D9="License",Total_Licence_Quota<="180,000"),J9*0.05,IF(AND(D9="License",Total_Licence_Quota<="270,000"),J9*0.06,IF(AND(D9="License",Total_Licence_Quota>"270,001"),J9*0.12))))))

I have also attached the sheet if anybody can help?! :-)

I'm guessing handling the nesting wrong and/or i'm not using the AND IF appropriately. Any help would be greatly appreciated!

Thank you!

Two things:
- I don't see 'Total_Licence_Quota' in your file anywhere, so I'm not sure what that is in your formula?
- Take the quotation marks off the numbers - i.e. change "90,000" to just 90000, etc - you don't need them around numbers

Other than that, your formula should work. (But as an aside, your final greater than 270,001 should just use 270,000 as the previous step is less than or equal to 270,000.)

Hope that helps.

[moving follow-up question to new post]