Minimum Origin Version Required: 2021

Similar to MS Excel's LET() function. Assign values to variables, for up to 39 variable-value pairs, for use in expression. Optional $ is used is used when returning strings.


LET(name1,value1[,name2,value2,]...[,name39, value39], expression)[$]


name1 ... name39

the variable name paired with values var1 through var39

value1 ... value39

the value(s) paired with name1 through name39


expression to be evaluated using value1 ... value39


use $ when returning a string


Return the result of expression.


newbook; //start a new workbook
wks.nCols = 3; //set number of columns to 3
patternT irng:=1 text:="A B C" mode:=random; //fill 1st column with random A, B and C
patternT irng:=2 text:="A B C" mode:=random; //fill 2nd column with random A, B and C
//set column C value as 500 if column A&B have same value, otherwise set C as missing value
//The LET() function assigns if() function result to t and calculate t*500
csetvalue col:=col(C) formula:="LET(t,if(A$==B$,1,0/0),t*500)";

See Also