Classification Formulas – Solibri Desktop Help Center

Version: 25.3

Available to Solibri Office users, powerful functions can be used to enhance workflows in ITOs and Classifications.

Site users can view and run formula columns but not make edits.

Column Labelling

Classification columns are labelled with letters (A, B, C, etc.) to help identify columns when writing formulas.

Formulas in Classifications allow dynamic values instead of static text. In Classification Name, users can choose between:

The formula field always starts with an equals sign (=), which cannot be removed or edited.
As you type, auto-suggestions appear, filtering available column names and suggesting supported functions.
When selecting a function, it is inserted with parentheses, and the cursor is placed inside the first parenthesis for easy input.

When a new column is added it will be positioned to the left of an existing column.
- This might shift the lettering of existing columns (e.g., what was previously "B" may become "C").
- However, formulas automatically adjust and retain references to the correct columns.
- This also applies when reordering columns—formulas remain intact despite changes in column positions

Table 3. Logic Functions

Function	Description
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; ...)

Table 4. Math Functions

Function	Description
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)
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; ...)
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; ...)

Table 5. Text Functions

Function	Description
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)
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)

Table 6. Validation and Info Functions

Function	Description
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)
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; ...)

Table 7. Operators

Function	Description
+	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 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
>=	Greater Than or Equal: Checks if one value is greater than or equal to another. Example: 3 >= 5 → FALSE
<=	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