0
Which tool in excel 2013 should you use if you know the correct answer but you don't know the input value that you need to get there?
Wiki User
∙ 7y ago
Goal Seek.
Wiki User
∙ 6y ago
Add your answer:
Earn +20 pts
Which tool in Excel should you use if you know the answer but you don't know the input value?
You would use Goal Seek.
What are Error And Input Messages Excel?
When using the Validation facility you can set an Input message to tell the user what they should enter like "Enter a value between 1 and 100". You can set an Error message to show if they do not enter a value that is valid.
What should be the value of capacitor at transistor amplifier circuit input?
at full input, if the transistor is working, the value of capacitor will be 0.
How to calculate IC 50 value using Excel?
ED50V10 (Readme) is an Excel add-in for calculating IC50/EC50 values. Input your data in the left columns, and your results will be shown in the right half of the Excel table. To calculate IC50, input 50 in the "INTERPOLATE..." table (highlighted in blue), the result will be shown on the right (highlighted in green).
What tool is used to create new input values when given a desired end result in Excel?
The Solver. You can also use Goal Seek to get a single value.
Which Excel tool adjusts the values in multiple input cells to either maximize minimize or reach a specific output value given appropriate constraints?
The Solver.
How do you enter same value in every cell in Excel in mac entourage?
There is no direct connection between Excel and Entourage, but if you highlight all the cells from Excel and go to Entourage, you should be able to paste the data.
How accurate is the Future Value Calculator?
The Future Value Calculator bases its responses on your input of rate per period, payment amount, present value etc. If your input for these values is accurate than Future Value Calculator should be fairly accurate.
What is the value of an alembic Excel 5 string bass?
what is the value of an alembic excel 5 string bass
What is an input value?
An input value is the value that you start with. If it helps, you can think of an input value as being a value you type in. So, for instance, if you type 8 * 2 into your calculator, then that's the input. This is contrasted with output, which is the value returned to you by the computer program. In our example, the output would be 16.
What is the output value if the input value is 4?
Anything you like - it depends on the function that relates the output to the input.
How does a change in the value of an input variable affect the value of an output variable?
The change in the input value is equalto the change in the output value.
