Supported Functions in Solibri Formulas

[tonigyllenberg]

Below are the supported functions available in Solibri Formulas:

Logic Functions

• AND – Returns TRUE if all arguments are true.
  Syntax: AND(value1; value2; ...)

• IF – Returns one value if a condition is true, another if false.
  Syntax: IF(condition; value_if_true; value_if_false)

• IFERROR – Returns a value if an expression results in an error.
  Syntax: IFERROR(value; value_if_error)

• NOT – Returns the logical negation of an argument.
  Syntax: NOT(value)

• OR – Returns TRUE if any argument is true.
  Syntax: OR(value1; value2; ...)

---

Math Functions

• ABS – Returns the absolute value of a number.
  Syntax: ABS(number)

• ACOS – Returns the arccosine of a number.
  Syntax: ACOS(number)

• ASIN – Returns the arcsine of a number.
  Syntax: ASIN(number)

• ATAN – Returns the arctangent of a number.
  Syntax: ATAN(number)

• ATAN2 – Returns the arctangent of the quotient of two numbers.
  Syntax: ATAN2(x number; y number)

• AVERAGE - Returns the average of a list of numbers.
  Syntax: AVERAGE(number1; [number 2]...)

• COS – Returns the cosine of a number.
  Syntax: COS(number)

• DEGREES – Converts radians to degrees.
  Syntax: DEGREES(angle)

• CEILING – Rounds a number up to the nearest integer.
  Syntax: CEILING(number)

• FLOOR – Rounds a number down to the nearest integer.
  Syntax: FLOOR(number)

• INT – Returns the integer part of a number.
  Syntax: INT(number)

• MAX – Returns the maximum value from a list.
  Syntax: MAX(number1; number2; ...)

• MIN – Returns the minimum value from a list.
  Syntax: MIN(number1; number2; ...)

• MOD – Returns the remainder of a division operation.
  Syntax: MOD(number; divisor)

• PI – Returns the value of π (pi).
  Syntax: PI()

• POWER – Raises a number to a specified power.
  Syntax: POWER(base; exponent)

• PRODUCT – Returns the product of a list of numbers.
  Syntax: PRODUCT(number1; number2; ...)

• RADIANS – Converts degrees to radians. Syntax: RADIANS(degrees)

• ROUND – Rounds a number to a specified number of decimal places.
  Syntax: ROUND(number; num_digits)

• ROUNDDOWN – Rounds a number down to a specified number of decimal places.
  Syntax: ROUNDDOWN(number; num_digits)

• ROUNDUP – Rounds a number up to a specified number of decimal places.
  Syntax: ROUNDUP(number; num_digits)

• SIN – Returns the sine of a number.
  Syntax: SIN(number)

• SQRT – Returns the square root of a number.
  Syntax: SQRT(number)

• SUM – Returns the sum of a list of numbers.
  Syntax: SUM(number1; number2; ...)

---

Text Functions

• CONCAT – Concatenates multiple strings into one.
  Syntax: CONCAT(text1; text2; ...)

• EXACT – Checks if two strings are exactly the same.
  Syntax: EXACT(text1; text2)

• FIND – Returns the position of a substring within a string.
  Syntax: FIND(substring; text; start_num)

• FIXED - Formats a number as text with a fixed number of decimal places.
  Syntax: FIXED(number;[decimals];[no_commas])

• LEFT – Returns the left part of a string.
  Syntax: LEFT(text; num_chars)

• LEN – Returns the length of a string.
  Syntax: LEN(text)

• LOWER – Converts a string to lowercase.
  Syntax: LOWER(text)

• MID – Extracts a substring from the middle of a string.
  Syntax: MID(text; start_num; num_chars)

• PROPER – Capitalizes the first letter of a string and converts the rest to lowercase.
  Syntax: PROPER(text)

• RIGHT – Returns the right part of a string.
  Syntax: RIGHT(text; num_chars)

• TRIM – Removes leading and trailing spaces from a string.
  Syntax: TRIM(text)

• UPPER – Converts a string to uppercase.
  Syntax: UPPER(text)

• VALUE – Converts a string to a number.
  Syntax: VALUE(text)

---

Validation & Info Functions

• ISBLANK – Checks if a value is blank.
  Syntax: ISBLANK(value)

• ISLOGICAL – Checks if a value is a logical value (TRUE or FALSE).
  Syntax: ISLOGICAL(value)

• ISNONTEXT – Checks if a value is not text.
  Syntax: ISNONTEXT(value)

• ISTEXT – Checks if a value is text.
  Syntax: ISTEXT(value)

• ISNUMBER – Checks if a value is a number.
  Syntax: ISNUMBER(value)

• CHOOSE – Returns a value from a list based on an index number.
  Syntax: CHOOSE(index_num; value1; value2; ...)

---

Operators

• + – Addition: Adds two values.
  Example: 5 + 3 → 8

• & – Concatenation: Joins two strings together.
  Example: "Hello" & " World" → **“Hello World”`

• / – Division: Divides one number by another.
  Example: 10 / 2 → 5

• = – Equality: Checks if two values are equal.
  Example: 5 = 5 → TRUE

• > – Greater Than: Checks if one value is greater than another.
  Example: 10 > 3 → TRUE

• >= – Greater Than or Equal: Checks if one value is greater than or equal to another.
  Example: 3 >= 5 → FALSE

• < – Less Than: Checks if one value is less than another.
  Example: 2 < 10 → TRUE

• <= – Less Than or Equal: Checks if one value is less than or equal to another.
  Example: 7 <= 7 → TRUE

• * – Multiplication: Multiplies two values.
  Example: 4 * 3 → 12

• != – Not Equal: Checks if two values are not equal.
  Example: 8 != 5 → TRUE

• ^ – Power: Raises a number to a power.
  Example: 2 ^ 3 → 8

• - – Subtraction: Subtracts one value from another.
  Example: 9 - 4 → 5

---