Let-func
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(var1,val1[,var2,val2,]...[,var39, val39], expression)[$]
var1 ... var39
val1 ... val39
expression
$
Return the result of expression.
newbook; wks.nCols = 4; patternT irng:=1 text:="A B C" mode:=random; patternT irng:=2 text:="A B C" mode:=random; csetvalue col:=col(C) formula:="LET(t,if(A$==B$,1,0/0),t*500)";