I think many of us find Excel based exams are great in alleviating math calculations in general, however, it is a bit cumbersome if we have to solve math equations in the Excel environment. Just wondering if there is any good way (or best practice) to handle equation solving in Excel.
I’m using RF and what they’ve been doing in their practice problems is setting a cell equal to the unknown variable with an initial guess, then do the problem normally, then adjust the unknown variable until the question conditions are met. I haven’t minded that method too much because, for me, it usually is faster than trying to convert solving an algebraic equation into Excel.
Another method is to put each number and each set of non-numbers in its own cell:
A5 B5 C5 D5 E5
3.5 “(x-” 12 “)=” 17
It takes a little longer to type out that way, but it’s very readable, and you can do straight references to combine numerical pieces as you solve the equation.
I think that’s a great idea. How would you solve the unknown after that? Or do you mind sharing which RF problem had this example? Thanks!
Thanks for sharing. I think this is a good idea too.
It looks like it was Crystal Clear that does this. Here is a snippet of solving BKM spot rate formulas:
It’s very nice for following their solutions, I’m less convinced it is helpful for exam conditions. I’ve been doing it maybe 1/4 of the time.
That is what I have been doing as well. A useful extension is that for linear problems you can use the FORECAST function. Just get two seed values and extrapolate to get the answer. Most exam problems that expect you to solve for an unknown algebraically are linear, so this method is almost always applicable.
Even if the solution function isn’t linear, the linear function will probably get you really close still, and you can apply it again with your new solution point and one of your seed points iteratively until you get the accuracy you want.