Web reporting tools Finereport Most often use some of the functions in detail

Before separately listed the finereport commonly used text, the time function explanation, here should the general friend's request, tidied up the finereport most commonly used some functions!

SUM

SUM (Number1,number2,...): Specifies the sum of all numbers in a specified range of cells.

Number1,number2,...: 1 to 30 parameters or all numbers in a specified range of cells.

Note:

The function calculates the numeric values, logical values, and text expressions that are directly typed into the parameter.

If the argument is an array or reference, only the values referenced by the group or cell are evaluated.

Example:

SUM (70,80) equals 150.

SUM ("80,true") equals 151, the logical value "TRUE" as a calculation, "FALSE" as 0, and the text "70" as the 70来 calculation.

COUNT

Count (value1,value2,...): Calculates the number of numeric items contained in an array or data region.

Value1,value2,...: Parameters that can contain any type of data, but this function only calculates data of the numeric type.

Note:

Numbers, dates, or numeric parameters that are represented by text are counted, but error values or text value parameters that cannot be converted to numbers are ignored.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

AVERAGE

AVERAGE (Number1,number2,...): Returns the average of the specified data.

Number1,number2: The parameter used to calculate the mean.

Note:

The argument must be a number, or a name, array, or reference that contains a number.

If the array or reference parameters contain text, logical values, or blank cells, the values are ignored, but the 0 value in the cell participates in the calculation.

Example:

If A1:a6 is named "Ages", which equals 10,23,14,24,33 and 25 respectively, then:

AVERAGE (A1:A6) equals 21.5.

AVERAGE (Ages) equals 21.5.

If there is another age of 18, the average of all ages is: AVERAGE (a1:a6,18) equals 21.

CHAR

CHAR: Returns the corresponding character according to the specified number. The Char function converts the numeric code of other types of computers to characters.

Number: The digit that specifies the character, between 1-number: The number used to specify the character, between 1-65535 (including 1 and 65535).

Example:

CHAR (88) equals "X".

CHAR (45) equals "-".

DATE

Date (Year,month,day): Returns a series number that represents a specific date.

Year: Represents an annual number, which can be one to four digits.

Month: Represents the months.

If 1 month 12, the function takes the parameter value as the month.

If month>12, the function is incremented from the beginning of the year January. For example: DATE (2000,25,2) equals the number of series on January 2, 2002.

Day: Representative days.

If the date is less than or equal to the number of days of a specified month, the function takes this parameter value as a day.

If the date is greater than the number of days of a specified month, the function is incremented from the first day of the specified month. If the date is greater than the total number of days of two or more months, the function subtracts two months or

The remainder of multiple months is added to the third or fourth month, and so on. For example: DATE (2000,3,35) equals the number of series on April 4, 2000.

Note:

This formula is available if you need to work with part of a date in a formula, such as year or month.

If the year, month, and day are constants in the function rather than in the function, this formula will best reflect its effect.

Example:

DATE (1978,9, 19) equals September 19, 1978.

DATE (1211,12, 1) equals December 1, 1211.

MAX

Max (Number1,number2,...): Returns the maximum value in the argument list.

Number1,number2,...: 1 to 30 parameters that need to find the maximum value.

Note:

Parameters can be numeric, blank cells, logical values, or text expressions of numbers.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

If there is no number in the parameter, max returns 0.

Example:

MAX (0.1,0,1.2) equals 1.2.

MIN

Min (number1,number2,...): Returns the minimum value in the argument list.

Number1,number2,...: 1 to 30 parameters that need to find the minimum value.

Note:

If there is no number in the argument, the function min returns 0.

The parameter should be a number, a blank cell, a logical value, or a text string that represents a value. If the parameter is an error value, MIN returns an error message.

If an array or reference parameter contains resolvable text values, logical values, 0 values, or blank cells, the values will participate in the calculation, while the unresolved text values are ignored.

Example:

If B1:b4 contains 3,6,9,12, then:

MIN (B1:B4) equals 3.

MIN (b1:b4,0) equals 0.

Time

Time (Hour,minute,second): Returns a decimal that represents a specified number of times. Between 0:00:00 (12:00:00 a.m.) and 23:59:59 (,

1:59:59p. The time between (M.) can return a corresponding value between 0 and 0.99999999.

Hour: A number between 0 and 23.

Minute: A number between 0 and 59.

Second: A number between 0 and 59.

Example:

Time (14,40,0) equals 2:40 PM.

Time (19,43,24) equals 7:43 PM.

RANGE

The RANGE (from,to,step) function represents an example of a sequence of steps, starting with an integer from, with step for each step: until the integer to.

Note:

The range function has three parameter types

RANGE (to), default from 1,step is 1

RANGE (from,to), the default step is 1

RANGE (From,to,step), with reference to the above comment

Example:

RANGE (4) returns [1,2,3,4].

RANGE (-5) returns [].

RANGE ( -1,3) returns [ -1,0,1,2,3].

RANGE (0,5) returns [0,1,2,3,4,5].

RANGE (6,-1,-2) returns [6,4,2,0].

RANGE (4,1,1) returns [].

ARRAY

ARRAY (Arg1,arg2 ...): Returns a arg1,arg2,... An array of components.

Ar1,ar2,... A string or a number.

Example:

ARRAY ("Hello") =["Hello"].

ARRAY ("Hello", "World") =["Hello", "World".

ARRAY ("Hello", 98) =["Hello", 98].

Aray (67,98) =[67,98].

Extended reading:

1. Web Reporting Tools Finereport usage Summary of common functions (text functions)

2. Web Reporting tools Finereport usage Summary of common functions (date and Time functions)

3,finereport:www.finereport.com

Web reporting tools Finereport Most often use some of the functions in detail