One Column formula different rows

Closed

William - Sep 18, 2009 at 01:55 PM
patrowe423 - Jun 23, 2010 at 02:37 PM

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?

One Column formula different rows
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Transfer data from one excel worksheet to another automatically formula - Guide

2 responses

Answer 1 / 2

patrowe423
Jun 23, 2010 at 02:36 PM

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
Jun 23, 2010 at 02:37 PM

*** 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.

Answer 2 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 18, 2009 at 10:05 PM

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!