View Full Version : Microsoft Excel
Blondie76
12-10-2005, 01:31 PM
I have a questions regarding a formula to calculate an equation such as:
f(x) = 2x³ + 4x² + 5
I have 12 variables for x. Is there a way I can set this up in excel if I put all the x variables in one column and the f(x) equation in another to calculate the answers for each x variable?
Appreciate your help! :smile:
Mikeinsmd
12-10-2005, 01:38 PM
I have a questions regarding a formula to calculate an equation such as: f(x) = 2x³ + 4x² + 5 I have 12 variables for x. Is there a way I can set this up in excel if I put all the x variables in one column and the f(x) equation in another to cacluate the answers for each x variable? Appreciate your help! :smile:Oh for Gawds sake!! :duh:
Blondie76
12-10-2005, 01:42 PM
Oh for Gawds sake!! :duh:
Wow...wasn't expecting that kind of response. Maybe I should rephrase my question. How do I get the x in the function to replace with a number? I'm not all that great with excel.
Does that make more sense, I guess I'm making this harder than it needs to be. If you are going to make another sarcastic comment, don't bother commenting.
Ken King
12-10-2005, 01:47 PM
Yep,
Set up column A with your variables and then create the equation substituting "x" for the variable location (starting with A1). In this case your formula would be "=2*(A1^3)+4*(A1^2)+5"
Mikeinsmd
12-10-2005, 01:52 PM
Wow...wasn't expecting that kind of response. Maybe I should rephrase my question. How do I get the x in the function to replace with a number? I'm not all that great with excel.
Does that make more sense, I guess I'm making this harder than it needs to be. If you are going to make another sarcastic comment, don't bother commenting.
It was a joke!! Take a pill for christs sake!! :razz: :killingme
Blondie76
12-10-2005, 01:52 PM
Yep,
Set up column A with your variables and then create the equation substituting "x" for the variable location (starting with A1). In this case your formula would be "=2*(A1^3)+4*(A1^2)+5"
Thank you Ken! I guess I was making it too complicated :frown: This will help me check my homework problems!
Thank you again!
Blondie76
12-10-2005, 01:55 PM
It was a joke!! Take a pill for christs sake!! :razz: :killingme
Well unfortunately, your joke didn't provide an answer to my problem. So maybe you should of led with the joke then provided the answer? Anyhoo, Ken helped me so, I guess, thanks for the joke? :smile:
Mikeinsmd
12-10-2005, 01:59 PM
Well unfortunately, your joke didn't provide an answer to my problem. So maybe you should of led with the joke then provided the answer? Anyhoo, Ken helped me so, I guess, thanks for the joke? :smile:
I was waiting for Ken to see if he got it right.... :whistle:
Ken King
12-10-2005, 02:02 PM
I was waiting for Ken to see if he got it right.... :whistle:
Was there any doubt? :yahoo:
Mikeinsmd
12-10-2005, 02:06 PM
Was there any doubt? :yahoo:
Ummmm..... no. Good answer Ken!! :high5: I would have come up with the same thing..... :whistle:
Dupontster
12-10-2005, 07:23 PM
Blonde Geometry Test
SEO by vBSEO 3.1.0 ©2007, Crawlability, Inc.