ui/src/scfuncs.src

38  *          Boolean flag whether function is suppressed. Usually 0. This may be
64  *              arguments can't be suppressed!
114 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
154 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
194 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
234 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
274 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
314 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
354 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
394 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
434 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
474 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
514 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
554 …Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
914 …       Text [ en-US ] = "Fixes the beginning of the week and the type of calculation to be used." ;
1074 …  Text [ en-US ] = "Future value. The value (final value) to be attained after the last payment." ;
1122             Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1170             Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1186 …   Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1242 …   Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1282             Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1298 …   Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1346 …Text [ en-US ] = "Periods. The periods for which the compounded interest is to be calculated. P = …
1370 …   Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1410 …Text [ en-US ] = "Period. The period for which the repayments are to be calculated. Per = 1 denote…
1490 …Text [ en-US ] = "The start period. The first period to be taken into account. A = 1 denotes the v…
1498             Text [ en-US ] = "End period. The last period to be taken into account." ;
1554 …Text [ en-US ] = "The start period. The first period to be taken into account. A = 1 denotes the v…
1562             Text [ en-US ] = "The end period. The last period to be taken into account." ;
1762 …r which the depreciation is calculated. The time unit used for period must be the same as that for…
1970 …Text [ en-US ] = "Guess. An estimated value of the rate of return to be used for the iteration cal…
2162             Text [ en-US ] = "The value to be tested." ;
2186             Text [ en-US ] = "The value to be tested." ;
2210             Text [ en-US ] = "The value to be tested." ;
2234             Text [ en-US ] = "The value to be tested." ;
2258             Text [ en-US ] = "The value to be tested." ;
2282             Text [ en-US ] = "The value to be tested." ;
2306             Text [ en-US ] = "The value to be tested." ;
2330             Text [ en-US ] = "The value to be tested." ;
2354             Text [ en-US ] = "The value to be tested." ;
2378             Text [ en-US ] = "The cell to be checked." ;
2426             Text [ en-US ] = "The value to be interpreted as a number." ;
2466             Text [ en-US ] = "The value for which the data type is to be determined." ;
2554             Text [ en-US ] = "An expression that can be either TRUE or FALSE." ;
2578             Text [ en-US ] = "Specifies a logical test to be performed." ;
2594             Text [ en-US ] = "Any value or expression which can be either TRUE or FALSE." ;
2634 …Text [ en-US ] = "Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and whi…
2658 …Text [ en-US ] = "Logical value 1, logical value 2;...are 1 to 30 conditions to be tested and each…
2683 …Text [ en-US ] = "Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and whi…
2707             Text [ en-US ] = "The number whose absolute value is to be returned." ;
2763             Text [ en-US ] = "The range in which empty cells are to be counted." ;
2803 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments whose total is to be calculated." ;
2827 …mber 1, number 2,... are 1 to 30 arguments for which the sum of the squares is to be calculated." ;
2851 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments to be multiplied and a result retu…
2875             Text [ en-US ] = "The range to be evaluated by the criteria given." ;
2891             Text [ en-US ] = "The range from which the values are to be totalled." ;
2916             Text [ en-US ] = "The range to be evaluated by the criteria given." ;
2932             Text [ en-US ] = "The range from which the values are to be averaged." ;
2956             Text [ en-US ] = "The range from which the values are to be totalled." ;
2964 …    Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
2997             Text [ en-US ] = "The range from which the values are to be averaged." ;
3005 …    Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3038 …    Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3071             Text [ en-US ] = "The range of cells on which the criteria are to be applied." ;
3103             Text [ en-US ] = "A positive value for which the square root is to be calculated." ;
3143             Text [ en-US ] = "The value to be tested." ;
3167             Text [ en-US ] = "The value to be tested." ;
3255             Text [ en-US ] = "A value between -1 and 1 for which the arccosine is to be returned." ;
3279             Text [ en-US ] = "A value between -1 and 1 for which the arcsine is to be returned." ;
3303 …en-US ] = "A value greater than or equal to 1 for which the hyperbolic cosine is to be returned." ;
3327             Text [ en-US ] = "The value for which the inverse hyperbolic sine is to be returned." ;
3351             Text [ en-US ] = "The value for which the inverse cotangent is to be returned." ;
3375             Text [ en-US ] = "The value for which the arctangent is to be returned." ;
3399 … smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned." ;
3423 … en-US ] = "A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned." ;
3447             Text [ en-US ] = "The angle in the radians for which the cosine is to be returned." ;
3471             Text [ en-US ] = "The angle in radians for which the sine is to be calculated." ;
3495             Text [ en-US ] = "The angle in radians whose cotangent value is to be returned." ;
3519             Text [ en-US ] = "The angle in radians for which the tangent is to be calculated." ;
3543             Text [ en-US ] = "The value for which the hyperbolic cosine is to be returned." ;
3567             Text [ en-US ] = "The value for which the hyperbolic sine is to be calculated." ;
3591 …  Text [ en-US ] = "A value not equal to 0 for which the hyperbolic cotangent is to be returned." ;
3615             Text [ en-US ] = "The value for which the hyperbolic tangent is to be calculated." ;
3671             Text [ en-US ] = "The angle in radians for which the cosecant is to be calculated." ;
3695             Text [ en-US ] = "The angle in radians for which the secant is to be calculated." ;
3719 …n-US ] = "The hyperbolic angle in radians for which the hyperbolic cosecant is to be calculated." ;
3743 … en-US ] = "The hyperbolic angle in radians for which the hyperbolic secant is to be calculated." ;
3839             Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ;
3871 …   Text [ en-US ] = "A value greater than 0 for which the natural logarithm is to be calculated." ;
3895             Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ;
3919             Text [ en-US ] = "The number for which the factorial is to be calculated." ;
3943             Text [ en-US ] = "The number to be divided." ;
3975             Text [ en-US ] = "The number for which the algebraic sign is to be determined." ;
4007             Text [ en-US ] = "The cells of the range which are to be taken into account." ;
4031             Text [ en-US ] = "The number to be rounded down." ;
4055             Text [ en-US ] = "The number to be truncated." ;
4063 …    Text [ en-US ] = "The number of places after the decimal point that are not to be truncated." ;
4087             Text [ en-US ] = "The number to be rounded." ;
4095             Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4119             Text [ en-US ] = "The number to be rounded up." ;
4127             Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4151             Text [ en-US ] = "The number to be rounded down." ;
4159             Text [ en-US ] = "The number of places down to which a number is to be rounded." ;
4183             Text [ en-US ] = "The number to be rounded up." ;
4207             Text [ en-US ] = "The number to be rounded up." ;
4231             Text [ en-US ] = "The number to be rounded up." ;
4271             Text [ en-US ] = "The number to be rounded down." ;
4279             Text [ en-US ] = "The number to whose multiple the value is to be rounded down." ;
4311 …Integer 1; integer 2,... are integers for which the greatest common divisor is to be calculated." ;
4335 …S ] = "Integer 1; integer 2,... are integers whose smallest common multiple is to be calculated." ;
4415             Text [ en-US ] = "The array for which the determinant is to be determined." ;
4439             Text [ en-US ] = "The array to be inverted." ;
4487 …Text [ en-US ] = "Array 1, array 2, ... are up to 30 arrays whose arguments are to be multiplied."…
4519             Text [ en-US ] = "Second array where the square of the arguments is to be subtracted." ;
4551             Text [ en-US ] = "Second array where the square of the arguments is to be totalled." ;
4659 …Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved…
4667 …Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherw…
4707 …Text [ en-US ] = "If type = 0 then the functions will be calculated in the form of y=m^x, or also …
4715 …Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherw…
4763 …Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved…
4811 …Text [ en-US ] = "If type = 0 then the functions will be calculated in the form of y=m^x, or also …
4859 … [ en-US ] = "Value 1, value 2, ... are 1 to 30 arguments representing the values to be counted." ;
4883 … number 2, ... are 1 to 30 numerical arguments for which the largest number is to be determined." ;
4907 … [ en-US ] = "Value 1, value 2,    are 1 to 30 arguments whose largest value is to be determined.";
4931 …number 2, ... are 1 to 30 numerical arguments for which the smallest number is to be determined." ;
4955 … en-US ] = "Value 1; value 2;... are 1 to 30 arguments whose smallest number is to be determined.";
5547             Text [ en-US ] = "The value for which percentage ranking is to be determined." ;
5571             Text [ en-US ] = "The value for which the rank is to be determined." ;
5619 …         Text [ en-US ] = "The percentage of marginal data that is not to be taken into account." ;
5659 …        Text [ en-US ] = "The start of the value interval whose probabilities is to be totalled." ;
5667 …     Text [ en-US ] = "The end of the value interval where the probabilities are to be totalled." ;
5739 …     Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ;
5763 …"The value for which the integral value of the standard normal distribution is to be calculated." ;
5787             Text [ en-US ] = "The value to be transformed (-1 < VALUE < 1)." ;
5811             Text [ en-US ] = "The value that is to be transformed back." ;
5963             Text [ en-US ] = "The value for which the Poisson distribution is to be calculated." ;
6003             Text [ en-US ] = "The value for which the normal distribution is to be calculated." ;
6051 … en-US ] = "The probability value for which the inverse normal distribution is to be calculated." ;
6091 …     Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ;
6115 …= "The probability value for which the inverse standard normal distribution is to be calculated." ;
6139 …          Text [ en-US ] = "The value for which the log normal distribution is to be calculated." ;
6187 …US ] = "The probability value for which the inverse log normal distribution is to be calculated." ;
6227 …          Text [ en-US ] = "The value to which the exponential distribution is to be calculated." ;
6267             Text [ en-US ] = "The value for which the gamma distribution is to be calculated." ;
6315 …[ en-US ] = "The probability value for which the inverse gamma distribution is to be calculated." ;
6355 … en-US ] = "The value for which the natural logarithm of the gamma function is to be calculated." ;
6380             Text [ en-US ] = "The value for which the Gamma function is to be calculated." ;
6405             Text [ en-US ] = "The value for which the beta distribution is to be calculated." ;
6469 … [ en-US ] = "The probability value for which the inverse beta distribution is to be calculated." ;
6525             Text [ en-US ] = "The value for which the Weibull distribution is to be calculated." ;
6621             Text [ en-US ] = "The value for which the T distribution is to be calculated." ;
6661 …Text [ en-US ] = "The probability value for which the inverse T distribution is to be calculated."…
6693             Text [ en-US ] = "The value for which the F distribution is to be calculated." ;
6733 …Text [ en-US ] = "The probability value for which the inverse F distribution is to be calculated."…
6773 …          Text [ en-US ] = "The value for which the chi square distribution is to be calculated." ;
6806 … which the probability density function or cumulative distribution function is to be calculated." ;
6848 …US ] = "The probability value for which the inverse chi square distribution is to be calculated." ;
6881 …"The probability value for which the inverse of the chi square distribution is to be calculated." ;
6914             Text [ en-US ] = "The value to be standardized." ;
7434 …Text [ en-US ] = "The X value for which the Y value on the regression linear is to be calculated."…
7490             Text [ en-US ] = "Specifies whether absolute or relative referencing is to be used." ;
7658 …    Text [ en-US ] = "The array (reference) for which the number of columns is to be determined." ;
7682 …       Text [ en-US ] = "The array (reference) for which the number of rows is to be determined." ;
7730             Text [ en-US ] = "The value to be found in the first row." ;
7754 …S ] = "If the value is TRUE or not given, the search row of the array must be sorted in ascending …
7778             Text [ en-US ] = "The value to be found in the first column." ;
7802 … = "If the value is TRUE or not given, the search column of the array must be sorted in ascending …
7874 …Text [ en-US ] = "The cell whose contents are to be evaluated is to be referenced in text form (e.…
7906             Text [ en-US ] = "The value to be used for comparison." ;
7922             Text [ en-US ] = "The vector (row or range) from which the value is to be determined." ;
7946             Text [ en-US ] = "The value to be used for comparison." ;
7962 …] = "Type can take the value 1, 0 or -1 and determines the criteria are to be used for comparison …
7994             Text [ en-US ] = "The number of rows to be moved either up or down." ;
8002 …       Text [ en-US ] = "The number of columns that are to be moved to the left or to the right." ;
8066             Text [ en-US ] = "The name of the Style to be applied." ;
8082             Text [ en-US ] = "The Style to be applied after time expires." ;
8122             Text [ en-US ] = "The range from which data is to be taken." ;
8130             Text [ en-US ] = "Defines how data is to be converted to numbers." ;
8298 …    Text [ en-US ] = "This is the text for which the code of the first character is to be found." ;
8378             Text [ en-US ] = "The text from which nonprintable characters are to be removed." ;
8426             Text [ en-US ] = "The first text to be used for comparing texts." ;
8458             Text [ en-US ] = "The text to be found." ;
8466             Text [ en-US ] = "The text in which a search is to be made." ;
8498             Text [ en-US ] = "The text to be found." ;
8506             Text [ en-US ] = "The text in which a search is to be made." ;
8538             Text [ en-US ] = "The text in which extra spaces between words are to be deleted." ;
8562 …Text [ en-US ] = "The text in which the beginning of words are to be replaced by capital letters."…
8586 …         Text [ en-US ] = "The text in which lower case letters are to be converted to capitals." ;
8634             Text [ en-US ] = "The text to be converted to a number." ;
8658             Text [ en-US ] = "The numeric value to be converted." ;
8690             Text [ en-US ] = "The value to be checked and returned if it is text." ;
8714             Text [ en-US ] = "The text in which some characters are to be replaced." ;
8722             Text [ en-US ] = "The character position from which text is to be replaced." ;
8730             Text [ en-US ] = "The number of characters to be replaced." ;
8738             Text [ en-US ] = "The text to be inserted." ;
8762             Text [ en-US ] = "The number to be formatted." ;
8770 …  Text [ en-US ] = "Decimal places. The number of fixed decimal places that are to be displayed." ;
8802             Text [ en-US ] = "The text in which the length is to be determined." ;
8826             Text [ en-US ] = "The text where the initial partial words are to be determined." ;
8858             Text [ en-US ] = "The text in which the end partial words are to be determined." ;
8890             Text [ en-US ] = "The text in which partial words are to be determined." ;
8898             Text [ en-US ] = "The position from which the part word is to be determined." ;
8930             Text [ en-US ] = "The text to be repeated." ;
8938             Text [ en-US ] = "The number of times the text is to be repeated." ;
8962             Text [ en-US ] = "The text in which partial words are to be replaced." ;
8970             Text [ en-US ] = "The partial string to be (repeatedly) replaced." ;
8986             Text [ en-US ] = "Which occurrence of the old text is to be replaced." ;
9010             Text [ en-US ] = "The number to be converted." ;
9018             Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ;
9050             Text [ en-US ] = "The text to be converted." ;
9058             Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ;
9082             Text [ en-US ] = "The value to be converted.";
9122 …   Text [ en-US ] = "The number to be converted to a Roman numeral must be in the 0 - 3999 range.";
9130 … value increases, the more the Roman numeral is simplified. The value must be in the 0 - 4 range.";
9177 …    Text [ en-US ] = "Can be \"osversion\", \"system\", \"release\", \"numfile\", and \"recalc\".";
9200 …    Text [ en-US ] = "This is the text for which the code of the first character is to be found." ;
9246             Text [ en-US ] = "The value to be converted.";
9301             Text [ en-US ] = "The text to be converted to a number." ;
9332             Text [ en-US ] = "The text in which the length is to be determined." ;
9355             Text [ en-US ] = "The text in which the end partial words are to be determined." ;
9386             Text [ en-US ] = "The text where the initial partial words are to be determined." ;
9417             Text [ en-US ] = "The text in which partial words are to be determined." ;
9425             Text [ en-US ] = "The position from which the part word is to be determined." ;