# Pulling a cell with a formula but only changing certain parts

#### Thanhpi

##### New Member
Hello,

So when you pull a cell

say
 Result Stat Something =B2*(C3/C4)

<tbody>
</tbody>
So in A 3 i want it to say B3*(C3/C4) but if i were to pull the A2 Cell A3 would end up being =B3*(C4/C5)

How would i go about doing this?

up until now ive been editing a few hundred manualy but it gets boring when im sure there is someway to simplify the process.

Thanks for the help!

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### philwojo

##### Well-known Member
Seems like a good case for cell references, if you always want C3/C4 to remain the same, then try this in your first cell and drag it down.

Code:
``=B2*(\$C\$3/\$c\$4)``

#### Thanhpi

##### New Member
Giving it another try on the Table

 A result B stat C 1 =B1*(C1/C2) 10 4 2 =B2*(C1/C2) 2 6 3 5 4 6

<tbody>
</tbody>
A2 is what i want it to be when i pull it down but when i do pull it down it would normally be =B2*(C2/C3)

#### Thanhpi

##### New Member
Aha, thanks ill try it out! :D