Hi!
Assume your current retail price list is in the range
A1:A10.
In cell B1 enter this formula:
=A1-A1*.15
With cell B1 still selected use your mouse and point to
the little black square in the bottom right of the cursor.
The fat "+" sign will change to a skinny "+" sign. Left
click and hold then drag copy the formula down to A10.
Biff
-----Original Message-----
I know nothing about this and I am in a pickle. I don't
even know where to
type in the formula, so please spell it out for me in
kindergarten language.
I need a formula that will figure a percentage off.
I have a column that is Retail Price and I need a formula
that will auto
fill 15% off the retail price of each cell in the
previous column.
I hope I am explaining this correctly.
Thanks,
JB
.
|