Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array advance sum formula | Excel Discussion (Misc queries) | |||
Advance Filter Formula | Excel Discussion (Misc queries) | |||
formula for scheduling in advance | Excel Discussion (Misc queries) | |||
how i can copy colum and pest it in row? | Excel Discussion (Misc queries) | |||
Need some help with a formula...thanks in advance | Excel Discussion (Misc queries) |