copy a formula down the colum and advance it by row only
 

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

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

copy a formula down the colum and advance it by row only
 

I can manualy do it. I see what your saying on the $ but how do I have a
constant cell and have Excel advance the rest of the formula by 1 for each
new row. Here is what ai am looking at.

=3%*((B5*B7)+(C5*C7)+(D5+D7)+E5+D7))

Here is what I want the next one to look like
=3%*((B5*B8)+(B5*C8)+(B5*D8)+B5*E8))

Is there a way to drag the formula and have it advance like this?

PRODUCT DESCRIPTION

B C D E
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 $174.60 $464.74
27 11 1 3 $2.97 $121.87 $464.74
54 15 $5.27 $201.07






"Joel" wrote:

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

copy a formula down the colum and advance it by row only
 

Your two formulas are decidedly different
=3%*((B5*B7)+(C5*C7)+(D5+D7)+E5+D7))
=3%*((B5*B8)+(B5*C8)+(B5*D8)+B5*E8))

If you erred in typing the second formula and it should really be:
=3%*((B5*B8)+(C5*C8)+(D5*D8)+E5*E8))

then, make this formula look like this
=3%*((B$5*B8)+(C$5*C8)+(D$5*D8)+E$5*E8))

and copy it down


"ShoDan" wrote:

I can manualy do it. I see what your saying on the $ but how do I have a
constant cell and have Excel advance the rest of the formula by 1 for each
new row. Here is what ai am looking at.

=3%*((B5*B7)+(C5*C7)+(D5+D7)+E5+D7))

Here is what I want the next one to look like
=3%*((B5*B8)+(B5*C8)+(B5*D8)+B5*E8))

Is there a way to drag the formula and have it advance like this?

PRODUCT DESCRIPTION

B C D E
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 $174.60 $464.74
27 11 1 3 $2.97 $121.87 $464.74
54 15 $5.27 $201.07






"Joel" wrote:

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

copy a formula down the colum and advance it by row only
 

Duke,
You are a genious.
I did make a mistake and you were correct in your assumption.
Thanks, You are the man.
Sho

"Duke Carey" wrote:

Your two formulas are decidedly different
=3%*((B5*B7)+(C5*C7)+(D5+D7)+E5+D7))
=3%*((B5*B8)+(B5*C8)+(B5*D8)+B5*E8))

If you erred in typing the second formula and it should really be:
=3%*((B5*B8)+(C5*C8)+(D5*D8)+E5*E8))

then, make this formula look like this
=3%*((B$5*B8)+(C$5*C8)+(D$5*D8)+E$5*E8))

and copy it down


"ShoDan" wrote:

I can manualy do it. I see what your saying on the $ but how do I have a
constant cell and have Excel advance the rest of the formula by 1 for each
new row. Here is what ai am looking at.

=3%*((B5*B7)+(C5*C7)+(D5+D7)+E5+D7))

Here is what I want the next one to look like
=3%*((B5*B8)+(B5*C8)+(B5*D8)+B5*E8))

Is there a way to drag the formula and have it advance like this?

PRODUCT DESCRIPTION

B C D E
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 $174.60 $464.74
27 11 1 3 $2.97 $121.87 $464.74
54 15 $5.27 $201.07






"Joel" wrote:

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