Pulling a cell with a formula but only changing certain parts

[Thanhpi]

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!

 

[philwojo]

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.

=B2*($C$3/$c$4)

 

[Thanhpi]

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]

Aha, thanks ill try it out! :D