Excel 2024: Back into an Answer by Using Goal Seek
October 28, 2024 - by Bill Jelen
Do you remember from Discover New Functions by Using fx, that I showed you how to calculate a loan payment by using the Insert Function dialog? Back in that example, the monthly loan payment was going to be $493.54. I did not mention it at the time, but my monthly budget for car payments is $425.
If you are about the same age as me and spent your summers watching TV, you might remember a crazy game show called The Price Is Right. Long before Drew Carey, the venerable Bob Barker would give away prizes using a variety of games. One that I recall is the Hi Lo game. Bob would give you the car if you could state the price of the car. You would guess. Bob would shout Higher or Lower. I think you had 20 seconds to narrow your guesses to the exact price.