![]() ![]() ![]() ![]() ![]() GoalSeek Goal:=Cells(k, "H"), ChangingCell:=Cells(k, "E") 'Go to next iteration Next k End Sub Goal Seek is a built-in tool in Excel that allows us to determine the value of one variable in our formula to obtain the desired result. The Goal Seek Excel function in Excel facilitates an automatic solving approach by adjusting a few pointers to reach a required output. Following a comment requesting help using my Goal Seek spreadsheet I have modified the macro to allow it to operate on a multi-column range. When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature available by clicking Goal Seek on the Tools menu. num What If Analysis -> Goal Seekā¦ to open the Goal Seek tool. To value: The value we are fixing is 60 here. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |