Sarabrooke
New Member
- Joined
- May 6, 2014
- Messages
- 14
One of the steps in my homework says to "Use Goal Seek to determine the optimal purchase price based on the objective of no more than 15% of available capital in cell B20 for the monthly payment."
I read a post earlier concerning this exact same question and I tried to follow the hints that were left but it kept saying that the cell must contain a value. Can someone explain to me what I may be doing wrong. I even tried deleting the formulas and just typing the numbers in and it was wrong.
I read a post earlier concerning this exact same question and I tried to follow the hints that were left but it kept saying that the cell must contain a value. Can someone explain to me what I may be doing wrong. I even tried deleting the formulas and just typing the numbers in and it was wrong.