ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   holding the result constant (https://www.excelbanter.com/excel-worksheet-functions/99419-holding-result-constant.html)

[email protected]

holding the result constant
 
I have used this functionality in the past, but have forgotten the
usage -- can someone please help?

Lets say a result is dependent on a number of variables:
f is a function of variables a,b,c,d...
Lets say I want f to be 15. What should be the value of "a" (assuming
other variables are held contstant), such that f comes out to be 15?
Again, I cannot remember how to do this, but I do remember that I had
used this functionality few years back.

Thanks for all inputs.


Max

holding the result constant
 
Perhaps it was:
Tools Goal Seek
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
I have used this functionality in the past, but have forgotten the
usage -- can someone please help?

Lets say a result is dependent on a number of variables:
f is a function of variables a,b,c,d...
Lets say I want f to be 15. What should be the value of "a" (assuming
other variables are held contstant), such that f comes out to be 15?
Again, I cannot remember how to do this, but I do remember that I had
used this functionality few years back.

Thanks for all inputs.




All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com