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!!

That didn't show how I anticipated

base price disc disc disc disc disc final price
10,000 25 10 5 5 2.5 ????


Hope this is better
"Grace" wrote in message
...
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!!

If I understand you correctly, with the Base Price in A5 and the number of
discounts in C8 try:

=A5*CHOOSE(C8,0.75,0.675,0.64125,0.6091875,0.59395 78125)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Grace" wrote in message
...
That didn't show how I anticipated

base price disc disc disc disc disc final price
10,000 25 10 5 5 2.5 ????


Hope this is better
"Grace" wrote in message
...
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!!

Assuming that your data is on row 2 and that 25 means 25% etc, and
that its real value is therefore 0.25, put this formula in G2:

=(1-SUM(B2:F2))*A2

If you don't want one of the discounts, just set it to 0 (or just
delete the cell contents).

Hope this helps.

Pete



On Aug 24, 8:16 pm, "Grace" wrote:
That didn't show how I anticipated

base price disc disc disc disc disc final price
10,000 25 10 5 5 2.5 ????

Hope this is better"Grace" wrote in message

...



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!!- Hide quoted text -

- Show quoted text -

Thank you Pete, but I don't want to add the discounts together and apply,
I want to take first discount, apply it to list, get the result .. then
apply the sencond discount to that result, all the way across... if there
is a discount % in the field...
Some items get one discount... some get two, some three ... etc...

Does that make sense?

Grace
"Pete_UK" wrote in message
ps.com...
Assuming that your data is on row 2 and that 25 means 25% etc, and
that its real value is therefore 0.25, put this formula in G2:

=(1-SUM(B2:F2))*A2

If you don't want one of the discounts, just set it to 0 (or just
delete the cell contents).

Hope this helps.

Pete



On Aug 24, 8:16 pm, "Grace" wrote:
That didn't show how I anticipated

base price disc disc disc disc disc final price
10,000 25 10 5 5 2.5 ????

Hope this is better"Grace" wrote in
message

...



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!!- Hide quoted text -

- Show quoted text -

Hello Grace,

Array-enter (enter with CTRL + SHIFT + ENTER, not only with ENTER)
=A1*PRODUCT(1-B1:F1%)

Unused discount cells should be deleted or filled with 0 (zero).

Regards,
Bernd

Thank you so much...
That seems to be exactly what I need!!!
Thanks again


"Bernd P" wrote in message
oups.com...
Hello Grace,

Array-enter (enter with CTRL + SHIFT + ENTER, not only with ENTER)
=A1*PRODUCT(1-B1:F1%)

Unused discount cells should be deleted or filled with 0 (zero).

Regards,
Bernd