Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

goal seek and solver

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Goal seek and solver

Goal seek and solver

ResolvedVersion 2003

Jon has attended:
Excel Advanced course

Goal seek and solver

Pls explain the main differences between goal seeker and solver

RE: goal seek and solver

Hi Jon

The main difference between the two is:

Goal seek allows you to achieve a known result by changing only ONE variable in the equation. eg:

(A3+A4) * A5/A6 = 375

If the answer is changed to 496 how will it change the value of cell A4

In Solver the same premise applies however you can change multiple cell values and even put in criteria

Hope this helps

Carlos

Mon 9 Feb 2009: Automatically marked as resolved.

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.