Divide Taxable amount within Tax rate and taxable Group

[hanif55]

Hallo Every One,

I Have a Calculation Problem . Please help me to resolve the same .

My sales men sent me His Sales Figure in Two Columns 1) Total Taxable amount 2 ) Total Vat Amount

Every time on receipts of This Figure I have to calculate again and again to bifurcate the

I Have 4 categories of tax Break 1 ) 14% 2) 9% 3) 6% 4) 2.5%

For Example if My Sales Men sends Me 1) Total Taxable Amount = 20000 and Total Vat Amount = 2300

I have to come up with any combination of VAT rate calculations that would sum up to 1) Total taxable amount and Total VAT Amount simultenously

My Ans : Will be 10000 * 14% = 1400 + 10000 * 9% =900 Total Amount = 20000 and Total Vat Amount = 2300
Please Provide formula to achieve the Given target
Thanks in Advance

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[hanif55]

I have uploaded the attachment correctly this time.

[hanif55]

Any Luck.....?

[alansidman]

What is the criteria for applying VAT rates. This is needed to apply Excel logic. Since I don't live in your country, I am unfamiliar with your taxing authority and its regulations.