Functions in the Formula Editor

Mathematical operations:

+	Addition
-	Subtraction
*	Multiplication
/	Division
^	Involution
sqrt()	Rootsquaring

 

Logical comparison and selection:

==	equally
>	more
<	less
!	not
|	or
!=	not equal
>=	not less
<=	no more
||	or
&&	and

Functions:

math:

Cos, Sin, Tg - trigonometric functions, the argument given in degrees.

Acos, Asin, Atg - inverse trigonometric functions, the result is given in degrees.

Abs - absolute value of (module).

Int - rounding to whole number.

Summ - returns the sum of the values of the variables in a grouped cells.

Note:

When you type a function should pay attention to the opening and closing brackets.

For example:

Summ(Row) - returns the sum of the numbers of grouped rows..

Summ(Standartnaya_detal.L) - returns the sum of the values ??of the L parameter object "standard part" in the grouped rows.

data conversion:

Str - Data conversion to a string type.

Num - conversion of data into a numeric type.

Frm - convert a numeric value to a string formatted according to the settings of a table column.

For example:

Frm(0.001230) returns a string 0,0012, if the column containing the cell is set to zero suppression and accuracy of 0,0000

selection and comparison:

FmtText - Addition formatted strings.

FmtSub - the creation of a subscript.

FmtSuper - create superscript.

FmtDigit - transfer number in hard copy.

FmtRaw - text without formatting.

DmtDiv - creation of fractions.

If/Iff - The logical choice. Recording Format:

if (Logich_Uslovie; Esli_Istina; Esli_Lozh)

where:

Logich_Uslovie - logical condition using logical comparisons (see above);

Esli_istina - the return value when the logical condition;

Esli_Lozh - return value at default logical condition.

For example:

if(object == Marker_universalny; Marker_universalny.position; "Undefined") . If an object type, which is connected with the cell column has Marker_universalny value, the function returns the position value of the referenced object. Another type of object it returns a string Undefined .

Exist - Checks whether there is a constant: =IF(EXIST(Object.Name);Object.Name;0)

Min/Max - returns the minimum / maximum value listed in parentheses

For example:

Min(maskimalnoe_znachenie; MinValue ) - nourishes MinValue;

Max(maskimalnoe_znachenie; MinValue) - returns maskimalnoe_znachenie.

Count - returns the number of objects (for grouped rows in the table).

For example:

Count() - returns the number of objects associated with cells grouped rows.

Avg - Calculates the arithmetic mean of the arguments. Takes an arbitrary number of arguments understand ranges. Empty arguments are ignored.

Off - returns the value of the cell, given the relative index. The index is written in the format:

Off(string; column)

For example:

Off(-1;2) - returns the value of cell in the table on one line above (-1) and two columns to the right (2) of the current

Cell - the cell returns the value specified absolute index.

Merge (Cells,Expression) - brings together a range of Cells, if Expression is not equal to 0. Returns the value of Expression.

For example:

=merge(A5:C5; "Title")