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;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”) integrates cell A5 to C5, in the summary displays the text “Title”.
*SetHeight*() reference line height. In brackets the height value.
*Val*() – computes the value of the argument.
For example:
=val(“A”+“1”) – calculates the “A1”, and then uses it as another expression (obtained by the value in cell A1). If the argument – not a string, then he comes back, ie =val(10+2) – the same thing =10+2.
=val(“summ(AStr(off(0;-1))“Str(off(0;-1))”)”) – the amount of cells from rows A to D, the number which is introduced into the cell to the left of the current one. In most cases you can do without val. The classic example, when without it – no way: in a custom form, enter the cell address, then to take the value out of it. Create a variable Addr, associate it with an input field on a form and in the table do so: = val (Addr) function allows recursion: = val (val (“A” + “1”)) – to take the value of the cell whose address is recorded in cell A1. Nesting depth is limited to 64.
Geometry*(Object) – works as *Implement object. Height embedded object shrinks to the line height. Object is taken from the report, or attached to the cell.
*SUMM) – Sum of cells in the current column of the section next to the current.
*COUNT*(Section(A3)) – The number of rows in the section containing the cell A3.
Reserved variables:
Pi – pi.
Row – for each cell in the column it returns the number of rows (rows are numbered starting with 1, excluding the header lines).
Col – for all cells in a column returns the column number of the table (column “A” is number 1).
Object – returns the type of the object, which is associated with the cell line.
Object1, Object2, – objects attached to the cell.
Title – the name of the table.
RowCount – total number of rows.
ColCount – the total number of columns.
Feedback
Post your comment on this topic.