Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Inputing a Value based on a Condition | Excel Worksheet Functions | |||
inputing data using vba | Excel Discussion (Misc queries) | |||
inputing data | Excel Discussion (Misc queries) | |||
inputing different days in a month for a formula | Excel Discussion (Misc queries) | |||
inputing formula | Excel Worksheet Functions |