[Solved] Copy cells with formula referencing a fixed cell

[GarethG]

I am a newbie to the forum so this may seem a very basic question. I tried to find the answer in other posts but no success. Basically I want to use a formula for a simple calculation which refers to a cell with a base rate. EG
Cell A1 has a base rate of 10
Cell A5 has a value entered of 2
Cell B5 has a formula =A5*A1 to give the result of 20
Then I want to copy the formula down the column so it picks up whatever is entered in column 1 and multiplies by A1 for each row. When I copy it it moves the reference and I have manually set the formula to A1 for each one.
Help would be appreciated. Thanks

[FJCC]

In B5 use the formula

Code: Select all

= A5 * $A$1

Using the $ symbols in the reference to A1 makes it an absolute reference that will not adjust as you copy the formula.

[robleyd]

For more information, see [Tutorial] Absolute, relative and mixed references

[GarethG]

Thanks for the replies - now all working well.