Solving equations in Excel based examines

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.

1 Like

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.