There is one more really important thing that I want to show you about how Python works in Excel. As you saw in the previous figure, I added the Python variable assignment to cell A4.

How to Use Variables in Excel. Knowing how to use Excel's variables gives you the ability to make your formulas – and by extension the spreadsheets containing those formulas – much easier to ...

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.