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

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

gimeabrek071 wrote:
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

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

You guys are the best!

Thank you

"bony_tony" wrote:

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

gimeabrek071 wrote:
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