Hi, I'm new to excel and I'm having trouble changing the cells in one of my formulas.
Basically I need to change the formula to represent the next row down for example =(G5/(G5+H5)*C5)*2.74 needs to change to =(G6/(G6+H6)*C6)*2.74.
At the moment I'm having to double-click each cell in the formula and choose the new cell manually and I have to do this a lot so as you can imagine its very time consuming.
Any help would be very much appreciated. Thanks
Basically I need to change the formula to represent the next row down for example =(G5/(G5+H5)*C5)*2.74 needs to change to =(G6/(G6+H6)*C6)*2.74.
At the moment I'm having to double-click each cell in the formula and choose the new cell manually and I have to do this a lot so as you can imagine its very time consuming.
Any help would be very much appreciated. Thanks