inputing formula

[amdx]

I want to calculate a number using data in column A.
The formula is 13536/pi*A (A is the data in column A)
I want to put the answer in column B
I want to multiply column B by .026
I want to put the answer in column C
I then have the fomula (A^2*B^2) / (18*A)+(40*C)
I want this answer in D.

I did somthing simular years ago, what I remember is:
Put data in column A
Go to formula bar and type an equals sign then the formula. Also something
about highlighting the column.
I haven't been able to make it work, what am I forgeting?
Thanks for your time and help
Mike

 

[Arvi Laanemets]

Hi

For row 2 enter formulas (start with =) into cells
B2=13536/(PI()*A2)
C2=B2*0.026
D2=(A2^2*B2^2)/(18*A2+40*C2)

Copy formulas down for same rows as there are data in column A


Arvi Laanemets

 

[Steve R]

Mike
Please post to only one group or, enter "Cross post" in the subject line so
everyone knows you've also asked the question elsewhere.

Steve