•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can LET Function calculation use cell containing text with variables?
Our take
Are you struggling to harness the full potential of the LET function in your spreadsheets? If you’ve ever wondered whether you can use cell references containing text variables for dynamic calculations, you're not alone. In this example, using `=LET(x,1,y,2,$B$1)` in cell A1 and expecting the result to reflect `x+y` from B1 is an intriguing challenge. Join us as we explore whether this approach is possible and how to achieve the desired outcome, unlocking new possibilities in your spreadsheet calculations.
For Example:
In cell A1, =LET(x,1,y,2,$B$1)
In cell B1, x+y
I want the result of A1 to be 3 because it read "x+y" from B1, is this possible?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience