| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating formulas
Use an Absolute Reference to cell C1.
=$C$1*A2 The $ symbols will prevent that reference from incrementing when you copy. HTH, Elkar "sunrock" wrote: I am trying to duplicate part of my formula in a column or row I created a formula using a1*b1 in c1 Now i want to use c1*a2 c1*a3 c1*a4 etc. How can I make that happen? Right now when I grab the plus at the bottom right if creates c1*a2 c2*a3 c3*a4 Help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| repeating formulas by the same row or colum increment as the last. | Excel Discussion (Misc queries) | |||
| repeating formulas by the same row or colum increment as the last. | Excel Discussion (Misc queries) | |||
| repeating formulas by the same row or colum increment as the last. | Excel Discussion (Misc queries) | |||
Threaded Mode
