Excel 2019: Back into an Answer by Using Goal Seek
October 21, 2019 - by Bill Jelen
Do you remember from “Discover New Functions by Using fx?
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.
A lot of times, I feel like those summers watching Bob Barker trained me to find answers in Excel. Have you ever found yourself plugging in successively higher and lower values into an input cell, hoping to arrive at a certain answer?