SEARCH |
Contact Us
HOME Excel |
Software |
Excel Formulas |
Excel Macros |
Free
Excel Help |
Excel Training |
Excel Development |
Newsletter |
SEARCH |
Contact Us
Apply Goal Seeker in Scenarios' Sheet
Back To Excel Model Analyzer Start
Apply Goal Seek in Active Scenarios' Sheet Use this tool to quickly find the values input variables should take to get a desired result
(output variable value.)
For example, If your current gross margin is $5,000.00 but you want to increase this margin to $9,000.00, how much should your
sales amount to?
This tool works only for input and output variables in the scenarios sheet which have
been created with the Scenarios' Sheet Wizard tool.In this example, consider the following output variables:
Retained Profit for the Year
Net Operating Profit (NOP)
Gross Margin
Assign values to them as in the screenshot: Retained Profit for the Year ($ 30,000.00 , $ 50,000.00 , $ 90,000.00)
Net Operating Profit (NOP) ($ 50,000.00 , $ 70,000.00 , $ 120,000.00)
Gross Margin ( $ 150,000.00 , $ 180,000.00 , $ 210,000.00)The tool automatically recognizes output variables and loads them into the form
so you can assign actual values to them.
Choose the destination where the results will be located, either in a new
sheet or in a specific range of the active sheet.If you do not want to analyze all variable outputs, uncheck the appropriate checkbox(es)
at the right of each variable you want to omit. Then click OK.Back To Excel Model Analyzer Start
Software Categories
Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software || Outlook Add-ins
MOST POPULAR! Excel to HTML
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us
