Help with autofilling a formula. TIA

[Cannibul]

Ok, I have a Excel sheet that is 42 row by 28 columns. The Rows each
reference a kH (carbonate hardness) value from 0.5 to 20 in 0.5 degree
steps. the Columns each reference a pH value from 6.0 to 8.6 in .1
degree steps. The formula I'm using 3 * KH * 10( 7-pH ) calculates
the CO2 level of the water. I would like to be able to just somehow
fill all these cells with the formula that references the correct row
and column and not have to enter the C and R values in each formula.

I'm sure this is possible but I'm not that experienced of an Excel
user.

Thanks.

 

[Frank Kabel]

Hi Cannibul
I assume that in column A your pH values are stored and in row 1 your
kH values. So your spreadsheet looks like this:
A B C
1 6.0 6.1
2 0.5
3 1.0

so your first formula would be in cell B2: enter the following:
=3*$A2*10*(7-B$1)
copy this formula and it should work

HTH
Frank

 

[Cannibul]

Many many thanks Frank. That was the help I needed.

 

[Frank Kabel]

Hi
Glad to be of some help
Frank

Many many thanks Frank. That was the help I needed.