
Use Goal Seek to find the result you want by adjusting an input …
If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Usar Buscar objetivo para encontrar el resultado deseado …
Si conoce el resultado que desea de una fórmula pero no está seguro de qué entrada es necesaria para obtener dicho resultado, use la característica Buscar objetivo de Excel.
Excel functions (by category) - Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. …
Introduction to What-If Analysis - Microsoft Support
If you know the result that you want from a formula, but you're not sure what input value the formula requires to get that result, you can use the Goal Seek feature.
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
Excel functions (alphabetical) - Microsoft Support
Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links …
Switch between various sets of values by using scenarios
The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel.
Using functions and nested functions in Excel formulas
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or …