## More LabTalk/SCV Functions Support

Version: 2019

Type: Features

Category: Programming

Subcategory: Labtalk

Jira: ORG-8422

More LabTalk/SCV functions are supported (or improved) e.g.,

• Integer-handling functions: Ceil(x), Floor(x), GCD(x1, x2,...),

• Convert(xa,xb)

• Engineering functions: Base(), Decimal(), BitLShift(), BitRShift()

• Math functions: Combina(number, number_chosen), Permut(number, number_chosen), Permutationa(number, number-chosen)

• Complex functions: Imcosh(c), Imcot(c), Imcsc(c), Imcsch(c), Imsec(c), Imsech(c), Imsinh(c), Imtan(c)

• Financial functions: pDuration(rate, pv, fv), RRI(nper, pv, fv), Effect(nominal_rate, npery), Nominal(effect_rate, npery)

• Statistical functions: Maxifs(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...), Minifs(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• Miscellaneous condition and switch functions:

• IfNA(value, value_if_na), xor(logical1, [logical2],…)

• if(con,val_true[,val_false]), if(con,val_true$[,val_false$])$• ifs(con1, d1[,con2, d2,]...[,con40,d40]), ifs(con1, str1$[,con2, str2$,]...[,con40, str40$])$• switch(expression, val1, res1[,val2,res2]...[,val39,res39][,default]), switch(expression, val1$, res1$[,val2$,res2$]...[,val39$,res39$][,default$])$• TextJoin(StringArray|String delimiter$, bool empty, StringArray text|String text1$,...)$

• IsFormula(string ref\$)