Excel can solve equations of the type y = f (x), ie allows you to find the value "x" for "and" die. For example, suppose the equation f (x) = X ^ 2 + x +1 have in cell "B1" value of y = 5, "B2", a value of x = 2 and in cell "B3" = f (x) - B1 = 2 . Clearly, if we want to solve y = f (x), it must find the value of x to the y = 5. For this objective function is used. You can download this file to learn how to use the objective function in Excel 2007.
0 comments:
Post a Comment