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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
You need to use what's called an "absolute reference". To lock formula on
column =$A1 copying down changes row, copying across has no change =A$1 copying down changes nothing, copying across changes column. For your situtation: =A3*$C$1 will work, or =A3*C$1 either will do. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kim" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Genius - thank you
"Luke M" wrote: You need to use what's called an "absolute reference". To lock formula on column =$A1 copying down changes row, copying across has no change =A$1 copying down changes nothing, copying across changes column. For your situtation: =A3*$C$1 will work, or =A3*C$1 either will do. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kim" wrote: 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. |
Reply |
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) |