Pulling a cell with a formula but only changing certain parts

[Thanhpi]

Hello,

So when you pull a cell

say[TABLE="width: 500"]
<tbody>[TR]
[TD]Result[/TD]
[TD]Stat[/TD]
[TD]Something[/TD]
[/TR]
[TR]
[TD]=B2*(C3/C4)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A result[/TD]
[TD]B stat[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]=B1*(C1/C2)[/TD]
[TD]10[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]=B2*(C1/C2)[/TD]
[TD]2[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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