Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging and Dropping Formulas
I want A1 (for example) to always be multiplied with a list of #'s in column
B with the results in column C. Is that clear? A1 should be multiplied by B1 thu B20 with the sum showing up in C1 thru C20. Currently my settings are allowing the first part of the formula (A1) to increase to one cell, A2,A3,A4, and so on as you drag. Please Help???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging and Dropping Formulas
Mike,
Try, =A$1*B1 and copy down as far as you need to go. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mike Bunch" <Mike wrote in message ... I want A1 (for example) to always be multiplied with a list of #'s in column B with the results in column C. Is that clear? A1 should be multiplied by B1 thu B20 with the sum showing up in C1 thru C20. Currently my settings are allowing the first part of the formula (A1) to increase to one cell, A2,A3,A4, and so on as you drag. Please Help???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging and Dropping Formulas
Use an Absolute Reference for A1. Typed as: $A$1
The $ symbols prevent the rows/columns from incrementing when the formula is copied. Could also be used as $A1 to prevent only the column from incrementing. Or A$1 to prevent only the row from incrementing. HTH, Elkar "Mike Bunch" wrote: I want A1 (for example) to always be multiplied with a list of #'s in column B with the results in column C. Is that clear? A1 should be multiplied by B1 thu B20 with the sum showing up in C1 thru C20. Currently my settings are allowing the first part of the formula (A1) to increase to one cell, A2,A3,A4, and so on as you drag. Please Help???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|