How to keep one variable in a formula static

[AdamW328]

Hi, how can I keep one variable in an excel formula static? For example, using the following formula, I want B1 to remain the same for the formula when I drag it down the column it is placed in

Formula:

=(B1/A2)/100

Then I want to be able to drag down the formula in column B so it would copy like this so only the "A" variable is changing:

=(B1/A2)/100
=(B1/A3)/100
=(B1/A4)/100
=(B1/A5)/100
etc

 

[Rick Rothstein]

Hi, how can I keep one variable in an excel formula static? For example, using the following formula, I want B1 to remain the same for the formula when I drag it down the column it is placed in

Formula:

=(B1/A2)/100

Then I want to be able to drag down the formula in column B so it would copy like this so only the "A" variable is changing:

=(B1/A2)/100
=(B1/A3)/100
=(B1/A4)/100
=(B1/A5)/100
etc

Place a $ sign in front of the part you don't want to change (that makes that part of the address absolute instead of relative). In this case, it is the 1 in B1...

=(B$1/A2)/100