One Column formula different rows
Closed
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?
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?
Related:
- One Column formula different rows
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
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.
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.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 18, 2009 at 10:05 PM
Sep 18, 2009 at 10:05 PM
IF J IS A CONSTANT THEN
you have to merely copy the formula down.
what is j
you have to merely copy the formula down.
what is j
Jun 23, 2010 at 02:37 PM