![]() ![]() ![]() Why doesn't Goal Seek find the exact value for 0 which I know exists?.Why is Solver giving me the infeasible solution prompt?.I guess here are my main questions are regarding the functionality of Goal Seek and Solver: Throughout this process however, I see what my payment should be through the iterations, so technically my prompt has been answered. ![]() The value at the end of the balance is fluctuating between $0.01 and -$0.01 before goal seek tells me that they "may not have found a solution". I tried using Solver after originally trying to solve this using Goal Seek. However, I am getting an error that says "Constraints Which Make the Problem Infeasible", but I am not using any constraints at all. Simple enough right? I am using Solver to set the last cell under the balance column to equal $0 by changing the first cell which is currently labeled at $100. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |