Microsoft Excel

Blondie76

New Member
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:
 
Last edited:

Mikeinsmd

New Member
Blondie76 said:
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

New Member
Mikeinsmd said:
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

A little rusty but not crusty
PREMO Member
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

New Member
Blondie76 said:
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

New Member
Ken King said:
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

New Member
Mikeinsmd said:
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

New Member
Blondie76 said:
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:
 

Dupontster

Would THIS face lie?
Blonde Geometry Test
 

Attachments

  • Test.jpg
    Test.jpg
    18.1 KB · Views: 61
Top