Something of Everything

How to solve equations in Excel?

 Many a times we encounter problems of solving equations within spreadsheet for engineering calculations. Suppose you want to solve n²-3n+1.5674 = 0, and want to find answer of the same in the middle of your engineering sum. 

There are two options available in excel for the same.
1.       You can use goal seek. Follow following procedure for using goal seek.

As shown in picture above you want x value for f(x) being 0.
a.       Go to Data -> What if analysis -> Goal seek

b.      In set cell provide cell reference of F(x) (you want F(x) to be 0, right?)
c.       In to value type 0.
d.      In by changing cell provide cell reference of cell of x (you want value of x for which f(x) becomes 0.)
e.      Press ok and see the result.
f.        As we know it should give us two options for which f(x) becomes 0. But, goal seek provides least value for which f(x) becomes 0.
2. You can use solver option for the solution.
a.       Go to data -> Solver (if you can’t find solver in data menu, go to options->add ins->Excel add ins -> solver add in and add the add in of solver.)
b.      In set object give reference of F(x)
c.       To value of 0
d.      In by changing cell give reference of x.
e.      Click solve and you get the result.

Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.


Posted

in

, ,

by

Tags:

Comments

Leave a Reply