Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula copied down
Is there a way to copy down a column this formula =F3*A2 and have the A2 stay
the same all the way down? The F3 would change on each row, F4, F5 etc. but the A2 would stay 'constant'. Thanks in advance for any help! |
#2
|
|||
|
|||
=F3*A$2
-- Ian -- "Pat" wrote in message ... Is there a way to copy down a column this formula =F3*A2 and have the A2 stay the same all the way down? The F3 would change on each row, F4, F5 etc. but the A2 would stay 'constant'. Thanks in advance for any help! |
#3
|
|||
|
|||
To keep part of a formula constant, precede the column or row number with the
dollar sign ($) So if you want A2 referenced all of the way down, write it as $A$2 Also, if you want just the column to remain a constant and the row change, write it as $A2 "Pat" wrote: Is there a way to copy down a column this formula =F3*A2 and have the A2 stay the same all the way down? The F3 would change on each row, F4, F5 etc. but the A2 would stay 'constant'. Thanks in advance for any help! |
#4
|
|||
|
|||
Thanks So Much!
"Steve Boxler" wrote: To keep part of a formula constant, precede the column or row number with the dollar sign ($) So if you want A2 referenced all of the way down, write it as $A$2 Also, if you want just the column to remain a constant and the row change, write it as $A2 "Pat" wrote: Is there a way to copy down a column this formula =F3*A2 and have the A2 stay the same all the way down? The F3 would change on each row, F4, F5 etc. but the A2 would stay 'constant'. Thanks in advance for any help! |
#5
|
|||
|
|||
Pat,
You need to make A2 an absolute cell reference, $A$2. The quick way is to click in the A2 (or next to it) in the formula bar, then press F4. That will put in the $. Press Enter to finish the edit. =F3*$A$2 Another, preferable, way, is to assign a range name to A2. Select it, click in the name box (left of the formula bar), type in a name, like Tax_Rate, press Enter. Now use: =Tax_Rate * F3 -- Earl Kiosterud www.smokeylake.com "Pat" wrote in message ... Is there a way to copy down a column this formula =F3*A2 and have the A2 stay the same all the way down? The F3 would change on each row, F4, F5 etc. but the A2 would stay 'constant'. Thanks in advance for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) |