eva/3 Application Builder • Developing eva/3 Applications • Working with expressions • functions 

Mathematic functions

Mathematic functions allow the treatment of numeric values. It is possible to round up or down numeric values or acquire the tangent of a value by mathematic functions.

Mathematic functions Syntax
ROUND
 Rounds a number up at a specified amount of decimal places , if the last value of the given decimal places is bigger or equal 5 and down, if the last value of the given decimal places is smaller then 5 . ROUND(number number; [number decimal places])

Number: The numeric value at which the function is to apply.

Decimal places: Amount of decimal places at which is to round up or down (default value=0).
ROUNDUP
 Rounds a number up at a specified amount of decimal places . ROUNDUP(number number; [number decimal places])

Number: The numeric value at which the function is to apply.

Decimal places: Amount of decimal places at which is to round up or down (default value=0).
ROUNDDOWN
 Rounds a number down at a specified amount of decimal places. ROUNDDOWN(number number; [number decimal places])

Number: The numeric value at which the function is to apply.

Decimal places: Amount of decimal places at which is to round up or down (default value=0).
MAX
 Acquires the biggest value of an amount of given values. Strings which contain numbers will be converted in numeric values and considered at the analysis. Other values will not be considered. The function needs at least one valid argument. MAX(number number1 ;[number number2] ;[number ...])

the biggest value will be acquired.
MIN
 Acquires the smallest value of an amount of given values. Strings which contain numbers will be converted in numeric values and considered at the analysis. Other values will not be considered. The function needs at least one valid argument. MIN(number number1; [number number2] ;[number ...])

Number1, Number2: A amount of numeric values from which the smallest value will be acquired.
AVG
 Acquires the mean value of an amount of given values. Strings which contain numbers will be converted in numeric values and considered at the analysis. Other values will not be considered. The function needs at least one valid argument. AVG(number number1; [number number2] ;[number ...])

Number1, Number2: A amount of numeric values from which the smallest value will be acquired.
SUM
 Acquires the sum of an amount of given values. Strings which contain numbers will be converted in numeric values and considered at the analysis. Other values will not be considered. The function needs at least one valid argument. SUM(number number1; [number number2]; [number ...])

Number1, Number2: A amount of numeric values from which the smallest value will be acquired.
COUNT
 Acquires the amount of the given values. The data type of the values will not be considered. COUNT(number number1; [number number2]; [number ...])

Zahl1, Zahl2: Values from which the amount will be acquired.
ABS
 Gets the absolute value of a number, which consists of a number without the sign. ABS(number number)

Number: The numeric value, from which the absolute value should be acquired.
ATN
-
ATAN
-
ARCTAN

Gets the arc tangent of a number. ATN(number number)

Number: The numeric value, at which the function is to apply.
COS Gets the cosine of number (of a angle). COS(number number)

Number: The angle given in radian, which cosine should be calculated.
EXP
 Potentises the base e with the given number. EXP(number number)

Number: Is the exponent, with each the base e is potentised.
HEX Creates from a numeric value a string which describes the value in hexadecimal format. Returns null , if the transfered value is null.

Example: =HEX(460) with the result 1CC 		HEX(number number)

Number: The number which has to be constitute in hexadecimal notation. If the number is no integer, then the value will be rounded to the next integer.
OCT
 Creates from a numeric valuea a string which describes the value in octal format. Returns null , if the transfered value is null.

Example: =OCT(460) with the result 714 		OCT(number number)

Number: The number which should be constitute in octal notation. If the number is no integer, then the value will be rounded to the next integer.
INT
 Rounds a real number at the next smaller integer down. Returns null , if the transfered numeric value is null . INT(number number)

Number: The real number which has to be rounded down to the next integer.
FIX
 Returns the integer part of a number, cuts at positive and negative number the decimal places. FIX(number number)

Number: The real number which has to be cut.
LOG
 Gets the logarith of a number to the given base. Returns null , if the transfered numeric value is null . LOG(number number)

Number: The positive real number, which logarithm should be calculated.
RANDOM
-
RND 		Gets a constant sectored random number bigger or equal 0 and smaller then 1. If a valuation is defined, then a integer value will be returned from this valuation. RANDOM([number from; number till])

From: The smallest possible number which can be returned from the valuation.

Till: The biggest possible number which can be returned from the valuation.
SIN
 Gets the sine of a valuation (angle). Returns null , if the transfered numeric value is null . SIN(number value)

Value: Is the angle given in radian, which sine shoul be calculated. order*PI()/180 = radian.
TAN
 Gets the tangent of a numeric value (angle). Returns null , if the transfered numeric value is null . Tan(number value)

Value: Is the angle given in radian,which tangent should be calculated. order *PI()/180 = radian.
PI
 Gets the value of the number PI (3.14159265...) PI()
SQR
 Gets the square root of the given numeric value. Returns null , if the transfered numeric value is null . SQR(number value)

Value: A numeric value from which the square root should be calculated.
FACT
 Gets the factorial of a number.

Example: =FAKULTÄT(4) Result: =24 Calculation formula: 		FAKULTÄT(number number)

Number: The numeric value, which factorial should be calculated.

The number must not be negative.Is the number no integer, then the decimal places will be cut.
POLYNOMIAL
 Gets the polynomial of a group from numbers.

Example: =POLYNOMIAL(values(2;3;4)) Result: =1260 Calculation formula: 		POLYNOMIAL(values values)

Numbers: The numbers are the values, from which the polynomial should be calculated.

Is one of the numbers smaller than 1, a exception occurs.
As well as if the value is no number.
There must be at least one and at most 29 numbers transfered.
FACTDOUBLE
 Gets a factorial for a number with the increment 2.

Example: =ZWEIFAKULTÄT(6) Result: =48 Calculation value:
Is the number a even number, then applies :

At a uneven value:
 ZWEIFAKULTÄT(number number)

Number1: The number, from which the double factorial should be calculated.

Is the number no integer, then the decimal places are cut.
The number must not be negative.
Is the value no number, then a exception appears.
ROMAN
 Converts a arabian in a roman number.

Example: =RÖMISCH(499;2) Result: =XDIX 		RÖMISCH(number number; [number type])

Number: The number, which should be converted.
The number must not be negative or bigger than 3999.

Type: Defines the type of the roman number .
Parameter cans be 0-4 .0 is the most classic variant, 4 the most simple.
the higher the type, the shorter the roman number.
Default value is the 0.
QUOTIENT
 Gets the integer part of a division.
Decimal places will be cut.

Example: =QUOTIENT(4,5;3,1) result: =1 		QUOTIENT(number numerator;hler;number denominator)

Numerator: Is the divident.

Denominator: Is the divisor.

is one of the both arguments not numeric, an exception occurrs.
POWERSERIES
 Gets the sum of powers.

Example: =POTENZREIHE(2;3;4; values(2;4;6;8)) Result: =274960.0 Calculation formula: 		POTENZREIHE(number x;number m;number x;values Values)

x:The value of the independent variables of the power series.

n: The starting power, in which x will be rised.

m: Is the increment, at which n in every element of the series reihe will be expandedd.

a: Are the coefficients, which will be multiplicate with successive potences of x .

If one of the arguments is not numeric, an exception appears.
CEILING
 Rounds a number at the smallest multiple. von Schritt auf.

Example: =OBERGRENZE(0,23;0,2) Result: =0,4 		OBERGRENZE(number value;number increment)

Zahl: Is the value which should be round.

Schritt: Is the value, at which increment should be rounded.

Number and increment must have the same signs
And both have to be numeric.
COMBIN
 Gets the amount of combinations of n without repitition of the element number k.

Example: =KOMBINATIONEN(8;2) Result: =28 Calculation formula: 		KOMBINATIONEN(number n;number k)



n: The amount of all elements.

k: Defines, from how many elements one combination should consist.

Both values must be numeric. Decimal places will be cutted to integers.
n and k must not be negative . n must not be smaller than k.
RADIANS
 Converts order in radian.

Example: =RADIANS(180) Result: =3.141592653589793 Calculation formula: 		RADIANS(number angle)

Angle: Angle given in order, which should be converted.
SQRTPI
 Gets the root of pi and the multiplicated number.

Example: =SQRTPI(12) Result: =6.139960247678931 Calculation formula: 		SQRTPI(number number)

Number: The number, which should be multiplicated with pi.

Number must not be negative.
VARIANCE
 Calculates the variance, starting from population.

Example: =VARIANCE(values(50;20;38)) Result: =152 Calculation formula: 		VARIANCE(values Values)

Values: Values from 1 to 30, which accord a population.
SGN
 Returns a value, which displays the sign of a number.

Example: =SGN(-56) Result: =-1 		SGN(number number)

Number: Number, from which the sign should be displayed.
  • Is the number equal null, then 0 will be returned
  • Is the number smaller than null, then -1 will be returned
  • Is the number bigger than null, then 0 will be returned
    		•
    INV Calculates the inverse of the given value.

    Example: =INV(5) Result: =0.2     		INV(number Zahl)

    Value: Value to be calculated

    functions functions