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