WinVask -  Faktura

Dataordliste: Matematiske Funksjoner

Dataordliste: Matematiske Funksjoner

Previous topic Next topic  

Dataordliste: Matematiske Funksjoner

Previous topic Next topic  

frb_bm12

 

Denne delen av Dataordlisten gir tilgang til innebyggede funksjoner for å manipulere tall.

 

ð        ABS() - Returns an absolute value from an expression. The absolute value of a number is always a zero. For example, C = ABS( A-B ). C would contain the absolute value of the difference of B subtracted from A
ð        INRANGE() - Compares a numeric expression for an inclusive range of numbers. Returns a value of true if the scope is met, and false otherwise. For example, INRANGE( variablename, 1, 5 ) would check if the variablename is with the numbers 1-5, and return true if so. The starting number is 1, and ending number is 5.
ð        INT() - Returns an integer value from a numeric expression. For example, INT( 8.5 ) would return a value of 8.
ð        LOGE() - Returns the natural algorithym. The natural logarithm of a value is the power to which e must be raised to equal that value. The value of e used internally for these calculations is 2.71828182846. For example LOGE(2.71828182846) returns 1; LOGE(1) returns 0
ð        LOG10() -Returns base 10 logarithm. If the value of the expression is zero or less, the return value will be zero. The base 10 logarithm is undefined for values less than or equal to zero. The LOG10 procedure returns the base 10 logarithm of a numeric expression. The base 10 logarithm of a value is the power to which 10 must be raised to equal that value. For example, LOG10(10) returns 1; LOG10(1) returns 0
ð        RANDOM() - Returns random integer.Returns a random integer between the low and high values, inclusively. The low and high parameters may be any numeric expression, but only their integer portion is used for the inclusive range. For example, RANDOM( 22, 80 ) would return a random number between the numbers 22 and 80.
ð        ROUND() - Returns a rounded number. For example, ROUND( 5163, 100 ) would return the rounded number of 5163+100 (which is 5200); ROUND(657.50,1) returns 658; ROUND(51.63594,.01) returns 51.64
ð        SQRT() - Returns the square root of a number.

 

To select a Dictionary item you can either double left click the mouse on an item or click the checkmark icon at the top left of the window (after highlighting your desired choice).