One Column formula different rows

[Closed]
Report
-
 patrowe423 -
Hello,

I have one formula for a column and 100 rows. The formula takes data from several different column cells on the same row. If I want to use the same formula for that colomn on every row, is there a way to have it automatically change the formula row to row without manually doing it. i.e. 1st row formula is: =(G1-G1*H1)*J-325 - 2nd row formula is: =(G2-G2*H2)*J-325 Do I have to change the formula for each row or is there formula that does this?

2 replies

Select the cell that contains the formula you want to replicate
Click copy
Go to Edit in menu bar and click Paste Special
Select Formulas

This will replicate the formula using the data in other rows.
*** after you copy, you have to select the cells in the column that you want the new formulas to be placed in/apply to. THEN go to Edit, Paste Special, etc.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
IF J IS A CONSTANT THEN
you have to merely copy the formula down.

what is j