Previous Topic Next Topic

One Column formula different rows

Closed
William - 18 Sep 2009 à 13:55
 patrowe423 - 23 Jun 2010 à 14:37
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?
Related:

2 responses

Réponse 1 / 2
patrowe423
23 Jun 2010 à 14:36
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.
patrowe423
23 Jun 2010 à 14:37
*** 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.
Réponse 2 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
18 Sep 2009 à 22:05
IF J IS A CONSTANT THEN
you have to merely copy the formula down.

what is j

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response