No one has the same problem?

[Guest]

I created a quote sheet and I can't figure out how to change discounts using
percentages.

many cells will have the product price and another cell is the discount
percentage offered to a specific customer.

I have customer that receive 6% and others may be higher. I would like to be
able to change the discount value for 6% to 8% and it would automatically
readjust the discount for all the product cell. I have the format of the
discount cell set to percentage. It will only minus the cells by .06 and not
by the percent.

Any help is greatly appreciated

 

[bony_tony]

Say you have the price in cell A1 and the discount value (as a
percentage) in cell B1, then the formula you need for the discounted
value would be - =A1-(A1*B1)

As I understand it, you are typing in =A1-B1 which will only take one
value away from another, ie $10.00 - 6% (0.06).
In my formula, (A1*B1) will calculate how much of the price the
percentage is, this is then taken away from the original price (A1)
giving you the dicounted amount!
Comprende?

Tony

 

[MartinW]

Hi,

Say your discount cell is B1 and your prices are in A3:A100.

In B3 put =A3*(1-$B$1) and copy it down to A100

Now you can plug any value you like into B1 and the discount price
in column B will adjust.

That's assuming that B1 is formatted to percentage if you want B1
to be general format then adjust the formula to =A3*(1-$B$1/100)

HTH
Martin