shortcut for changing value in formula

Hi there

I'm working with formulas in excell and need a shortcut if at all possible.

So the values in the A column are graduated from 0-6 in increments of 0.25

I need to enter a formula based on the information in the A cells into the B cells as follows

5.355*2.229*87.1*EXP(-2.229*z)/(1+87.1*EXP(-2.229*z))^2

where z = the corresponding entry in the A cell
For example, the first formula (A1/B1) would replace the z with 0, the second formula (A2/B2) would subsitute 0.25 for the z.

Any help gratefully received.....

Hi there

Thanks for your reply. However you misunderstand me! I need to change the value for each line. So for the A2 cell the formula would be

5.355*2.229*87.1*EXP(-2.229*A1)/(1+87.1*EXP(-2.229*A1))^2

but for the B2 cell it would be

5.355*2.229*87.1*EXP(-2.229*B!)/(1+87.1*EXP(-2.229*B1))^2

and C2 =

5.355*2.229*87.1*EXP(-2.229*C1)/(1+87.1*EXP(-2.229*C1))^2

and so on.......

Is there an easier way to do this except for having to change the column address for every line?

Thanks

I am using the same formula, but changing the value down the whole B column

5.355*2.229*87.1*EXP(-2.229*z )/(1+87.1*EXP(-2.229*z))^2

so where you can see I have inserted the z, the value will change for each line

going down the b column, the entry in b1 would replace z with a1

the entry in b2 would replace z with b1

the entry in c2 would replace z with c1

the entry in d2 would replace z with d1

and so on

the a column is filled with changing values of 0-6 in steps of 0.25, the formula inserted in the b column needs to reflect the changing value in the corresponding a column.

I hope this is a clearer explanation, I don't know how to explain it any other way!

Any Other Thoughts?