View Single Post
  #1   Report Post  
amdx
 
Posts: n/a
Default 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