More specifics would help... do you want to just replace every price shown
with a value that's 90% as much? Or is this a variable you need to set so
that you can adjust as needed?
I'll assume the latter (since it will get you the former)... Pick two
cells, one to be a label, one the value. For argument's sake, I'll assume
they're in A1 and B1. Enter the word Discount in A1 and 90% in B1.
Highlight both cells and Insert > Name > Define. Ensure that Excel is
creating the name Discount and that it references B1.
Now we need to apply the discount to your prices. I'll assume your existing
prices are in column B (with a product codes in column A), starting in row 4.
In c4, enter the equation =B4 * (1-Discount). The result should reflect the
discount applied to the old price. Autofill that formula by placing the
cursor over the lower right corner (it's called the fill handle); you'll see
the cursor change shape. Double-click and it should fill the column. Note
that if you change the discount in B2, all the prices in column C will change
in step.
Hope this is roughly what you were looking for. If not, please be as
specific as you can about what the output(s) should be.
