Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |