Need to calculate discount amounts

Hi,

My scenario is one where we know:

• Item Cost
• Cash on hand
• Tax rate
• Total Due

I need to make the Total Due match Cash On hand via adding in a discount amount (to be supplied by Excel) taking into account that the item cost will change, and so will the tax. So for example:

Cash on Hand 414.46

Item Cost 841
Freight 0
Tax Rate 6%
Tax Before Discount 50.46
Total Before Discount 891.46
Discount 450
Item Total with Discount 391
Tax with Discount 23.46
Total Due 414.46


Can you please help me setting up the formula to obtain the discount amount? I'm not a power user, but can follow most supplied formulas and steps.
Thanks very much!

Oh, whoops, sorry about that. Does this file help?

Thanks. Looks complicated, but I'm playing around and trying to understand it. Appreciate letting me know about this feature.

Yes, that worked nicely! Thanks very much.