How do I define and solve a maths equation using excel?

E

excel nub

eg. "A1*x^2 + A2*x= 4 " in cell B1
we know the values in cells A1 and A2 and both are constants.

how do we solve for x using goal seek?
 
N

Niek Otten

A1:5
A2:5
A3(x):5
A4:4
B1: =A1*A3^2+A2*A3-A4

Tools>Goal Seek
Set Cell: B1
To Value: 0
By Changing cell: A3

If you need more precision: Tools>Options>Calculation, change the Iteration
options

Niek Otten
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal Seeking via Excel 0
Excel - Wich Function should I use? 1
Finding asymptote equation and how to draw them in excel 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
VBA Coding Help for Beginner 0
Excel does not accept text format! 0
Solving two equations with known exponent 5
What is this called in Excel or how it works? 0

Top