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
|