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