Thread
:
discount formula help
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
discount formula help
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!!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann