View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve R[_3_] Steve R[_3_] is offline
external usenet poster
 
Posts: 11
Default inputing formula

When you use PI you need to have brackets after it
You need to reference a specific cell in column A.
You need to use an equals sign at the front of the formula.

Your formula at B1 becomes =13536/pi()*A1

Your Formula at C1 becomes = B1*.26

Your formula at D1 becomes = (A1^2*B1^2) / (18*A1)+(40*C1).

To adjust this formula to rows below:
a) highlight cell B1 to D1
b) Copy
c) highlight column B cells that you want the formula copied to
d) paste

HTH
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