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. |
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. |
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. |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com