inputing formula
 

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

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


"amdx" wrote in message
...
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

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

"amdx" wrote in message
...
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