Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I know this is probably a very basic question but hope someone can help. In
reference to copying formula... Lets say, for example that I have a number in C1 and I want the items in A3, A4, A5.. to multiply times c1 and produce the answer in B3, B4, B5.. I know the basic formula in B3 is =A3*C1 However if i just copy that formula and paste it in B4 it changes the formula to =A4*C2 when I want it to keeo the C1. Does that make sense? How do I keep the formula to keep referencing the C1 cell. I tried Paste special, formula only, etc but it keeps carrying the formula down to C2 or C3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |