Search : in
By :

One Column formula different rows

Last answer on Sep 19, 2009 3:05:09 am BST William, on Sep 18, 2009 6:55:55 pm BST 
 Report this message to moderators

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?

Configuration: Windows XP Internet Explorer 8.0

Best answers for « One Column formula different rows » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...

1

 venkat1926, on Sep 19, 2009 3:05:09 am BST

IF J IS A CONSTANT THEN
you have to merely copy the formula down.

what is j

Reply to venkat1926