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.