copy a formula down the colum and advance it by row only
Add $ to the column
You can either do A1 $A1 A$1 $A$1
the dollars sign are uused for copying cells to indicate you don't want the
column or row incrtemented when you do a copy
"ShoDan" wrote:
PRODUCT DESCRIPTION
3X5 RAS PAD 18X5 RAS PAD 18X18 RAS PAD RAS SOCK E/C CHARGE DELIVERY
P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE
$2.70 $2.00 $1.00 $1.00 3% OF PROD. $20.00
QTY DELV QTY DELV QTY DELV QTY DELV QTY DELV QTY DELV
43 16 2 $4.50
27 11 1 3 $2.97
54 15 $5.27
|