I have a worksheet formula I need help with.

Starting with a price as the base price -- I need to have 5 columns for
available discounts to be applied to the base price..

for ex. Discount discount discount disc
disc final price
.. $10,000 25 10 5
5 2.5 ???



Some line items will have 1 discount to apply
Some will have 2, some 3 , some 4 etc....

So depending on the numbers in the discount fields will determine how many
computations need to me made to the first number...

What is the best way to set this up?

Thank you!!