This question gets to the heart of a real frustration with traditional spreadsheets. The user wants `=LET(x,1,y,2,$B$1)` in cell A1 to evaluate the text string "x+y" stored in B1 as a live calculation. It's a simple, logical ask: define variables in one place, then write a formula as plain text in another cell, and have the spreadsheet execute it. But in standard Excel, it doesn't work. The `LET` function is powerful, but it can't parse a text variable from a cell reference into an executable expression. That gap is precisely why AI-native spreadsheets matter.
For the user, the practical barrier is that Excel treats text and formulas as separate worlds. You can store "x+y" in B1, but the spreadsheet sees only characters, not instructions. To get the result 3, you'd need to write the actual formula `=1+2` in A1 or use a workaround like `EVALUATE` in the legacy macro system, clunky, fragile, and not scalable. This isn't a user error; it's a design limitation. Traditional tools were built for static data entry, not dynamic, human-readable logic.
What this user is really asking for is a spreadsheet that understands intent. An AI-native approach would let you write `x+y` in B1 as text, define `x=1` and `y=2` in A1, and have the system interpret the relationship automatically. No macros, no hidden evaluation tricks. The spreadsheet becomes a conversational workspace where variables and formulas live in plain language, not locked inside rigid syntax. That transforms the question from "is this possible?" to "how do I start working this way?"
The answer today is that it's not possible in legacy tools, but it shouldn't stop you from exploring alternatives. If you feel constrained by the limits of traditional formulas, look for solutions that treat text as executable logic. The future of spreadsheets is one where you define the variables and the relationships, and the tool handles the execution. That's the shift. Not a revolution, just a smarter way to work.