Pulling a cell with a formula but only changing certain parts

Thanhpi

New Member
Joined
Feb 2, 2018
Messages
10
Hello,

So when you pull a cell

say
ResultStatSomething
=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!
 

Some videos you may like

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
Joined
May 10, 2013
Messages
533
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
Joined
Feb 2, 2018
Messages
10
Giving it another try on the Table

A resultB statC
1=B1*(C1/C2)104
2=B2*(C1/C2)26
35
46

<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)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,397
Messages
5,444,241
Members
405,276
Latest member
HerbertZ

This Week's Hot Topics

Top