Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with cell formula
I have 3 columns
column 1A I have the euro rate per uk £, I can change this as the rate changes. Column B5 - B22 I have various UK amounts,50p,£1,£2,£10 etc Column C5 - C22 will be the euro conversion for the UK amounts In C3 cell I have =1A*B5 this gives me the euro conversion. How do I apply the same formula all the way down column C without entering it in every cell? If I try and drag it down the column it starts at 1A*B5 then 2A then 3A, I want them all to refer to cell 1A. I hope I have explained ok. thanks Juco |
#2
|
|||
|
|||
Use what's called an "absolute" reference, put $ before the reference you
want to remain the same. =$A$1*B1 copied down will return =$A$1*B2 =$A$1*B3 etc. "Juco" wrote in message k... I have 3 columns column 1A I have the euro rate per uk £, I can change this as the rate changes. Column B5 - B22 I have various UK amounts,50p,£1,£2,£10 etc Column C5 - C22 will be the euro conversion for the UK amounts In C3 cell I have =1A*B5 this gives me the euro conversion. How do I apply the same formula all the way down column C without entering it in every cell? If I try and drag it down the column it starts at 1A*B5 then 2A then 3A, I want them all to refer to cell 1A. I hope I have explained ok. thanks Juco |
#3
|
|||
|
|||
Use absolute referemce which mean using dollar signs
=$A$1*B5 Regards, Peo Sjoblom "Juco" wrote: I have 3 columns column 1A I have the euro rate per uk £, I can change this as the rate changes. Column B5 - B22 I have various UK amounts,50p,£1,£2,£10 etc Column C5 - C22 will be the euro conversion for the UK amounts In C3 cell I have =1A*B5 this gives me the euro conversion. How do I apply the same formula all the way down column C without entering it in every cell? If I try and drag it down the column it starts at 1A*B5 then 2A then 3A, I want them all to refer to cell 1A. I hope I have explained ok. thanks Juco |
#4
|
|||
|
|||
Thanks thats got it working.
appreciated Juco "Peo Sjoblom" wrote in message ... Use absolute referemce which mean using dollar signs =$A$1*B5 Regards, Peo Sjoblom "Juco" wrote: I have 3 columns column 1A I have the euro rate per uk £, I can change this as the rate changes. Column B5 - B22 I have various UK amounts,50p,£1,£2,£10 etc Column C5 - C22 will be the euro conversion for the UK amounts In C3 cell I have =1A*B5 this gives me the euro conversion. How do I apply the same formula all the way down column C without entering it in every cell? If I try and drag it down the column it starts at 1A*B5 then 2A then 3A, I want them all to refer to cell 1A. I hope I have explained ok. thanks Juco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |