Formulas

[hassle]

1
100 rows of data
on each row I want H to represent column C minus column B
is there a way to set this up without doing it 100x?


2
on each row I want J to represent H divided by B
again-can this be setup without doing it 100x?

thank you-is there somewhere within openoffice help where this kind of info can be found?

[FJCC]

I'll assume your data start in row 2. In cell H2 enter

Code: Select all

=C2 - B2

After you press enter, click on H2 and you will see a small black square in the lower right corner. Click and hold on that and drag it down to cell H101. The formula will be copied into each cell you drag through and the cell references will adjust automatically.
The same procedure will work for you other formula except you should enter in J2

Code: Select all

=H2/B2

[RusselB]

I'm guessing that you already know the base formulas you need, but just in case, for your first situation, in H1 enter

Code: Select all

=C1-B1

For your second situation, the code would be

Code: Select all

=H1/B1

Note: If B1 is 0, then you will get an error in I1

As to what I think your real query is about, if your data is in consecutive rows, select the cell with the formula (eg: H1), then double click the little black box (aka the handle) located at the bottom right of that cell.

[hassle]

thank you very much-I will try these tomorrow when I have a minute