1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Can LET Function calculation use cell containing text with variables?

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?

submitted by /u/SteelMonger_
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#LET Function
#calculation
#cell
#Excel
#text
#variables
#A1
#B1
#result
#x
#y
#formula
#example
#variables calculation