How to put bounds/limits on Goal Seek function in Excel without VBA?
I'm using MS Office 2016 Professional Plus.
In Excel I'm trying to minimize a value in a cell by using What-If-Analysis and Goal Seek. But there is no options to set a limits on changing cell.
Here it is:
I can only set a target cell, target value and a changing cell. But I need changing cell to be changed within certain bounds: [0:1] (from zero to one)
Is there some way I can set bounds on Goal Seek without involving programming with VBA so it fluctuates within specified range?
Uploaded my Excel file to DropBox: SOQ.xlsx
Solution
Hi: use the solver instead of goal seek - this gives the control and flexibility you are looking for : binary constraints, integer and limits on other cell values in the linear path.
- Convert Range to a table
- In Excel, I wonder that how to use VLOOKUP function in OR logic
- Simple VBA array join not working
- Excel Pivot Table - Turn two columns with same values into a matrix pivot table with column names as rows and value count in columns
- Excel: Transforming automatically a cell based on the input in another one
- Check Duplicate Data
- Finding hidden or system files containing ~ using Dir() in VBA
- Deleting rows that do not have specific value (text) - throwing Error Code 13
- Filter function Delivers the Blank cells in the Array as Zeros and Other Blank cells in time formated cells as 12:00
- How to disable Excel's automatic cell reference change after copy/paste?
- Retrieve article name and store of cheapest article for a given category in Excel
- Filter function or alternative for Vertical and Horizontal Criteria
- Calculate SUMPRODUCT with multiple column criteria and one row criteria
- Format smallest value in range of same category in Excel
- Calculate SUMPRODUCT with multiple column criteria and one row criteria (with empty columns in the data range)
- How to group an array of shapes
- Extract text after last delimiter but exclude last character
- How do i calculate difference between counts for each value in Excel
- Highlight cell in a range if the cell value is same as the cell value in a column A
- How to count specific values between other values
- Excel Chart: color data labels by categories - rows
- Get table dynamically with name in excel
- Excel Chart: color data labels by categories - columns
- VBA Error 1004 occurs when manipulating a table
- Store location of cell and loop recursively
- Excel - 3D interpolation
- Excel Data Validation with XLOOKUP
- Using a list (range) of column critiera (not single cells) in FILTER formula
- Yield to maturity / IRR in Power Query M
- How to convert a worksheet to a Data frame in Pandas?