Lines Matching refs:a
9 * with the License. You may obtain a copy of the License at
26 * two blocks because otherwise we had a 64kb overflow.
28 * For every function there is a sub resource with the number of the OpCode of
66 * first the type or name of the parameter, second a description of the
88 Text [ en-US ] = "Counts the cells of a data range whose contents match the search criteria." ;
128 …Text [ en-US ] = "Counts all non-blank cells of a data range where the content corresponds to the …
168 …Text [ en-US ] = "Returns the average value of all the cells of a data range whose contents match …
208 …Text [ en-US ] = "Defines the contents of the cell of a data range which matches the search criter…
248 …Text [ en-US ] = "Returns the maximum value from all of the cells of a data range which correspond…
288 …Text [ en-US ] = "Returns the minimum of all cells of a data range where the contents correspond t…
328 …Text [ en-US ] = "Multiplies all cells of a data range where the contents match the search criteri…
368 …Text [ en-US ] = "Calculates the standard deviation of all cells in a data range whose contents ma…
408 …turns the standard deviation with regards to the population of all cells of a data range matching …
448 …Text [ en-US ] = "Adds all the cells of a data range where the contents match the search criteria.…
488 …Text [ en-US ] = "Determines the variance of all the cells in a data range where the contents matc…
528 …Text [ en-US ] = "Determines variance of a population based on all cells in a data range where con…
608 Text [ en-US ] = "Returns an internal number for a text having a possible date format." ;
624 …Text [ en-US ] = "A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date f…
656 Text [ en-US ] = "Calculates the number of days between two dates based on a 360-day year." ;
744 …Text [ en-US ] = "Determines the sequential number of a month of the year (1-12) for the date valu…
784 …Text [ en-US ] = "Determines the sequential number of the second of a minute (0-59) for the time v…
808 Text [ en-US ] = "Determines a time value from the details for hour, minute and second." ;
848 … Text [ en-US ] = "Returns a sequential number for a text shown in a possible time entry format." ;
864 …Text [ en-US ] = "A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time f…
920 Text [ en-US ] = "Returns the year of a date value as an integer." ;
1008 Text [ en-US ] = "Calculates the date of Easter Sunday in a given year." ;
1088 …ue. Returns the future value of an investment based on regular payments and a constant interest ra…
1128 Text [ en-US ] = "Present value. The current value of a series of payments" ;
1144 …e number of payment periods for an investment based on regular payments and a constant interest ra…
1176 Text [ en-US ] = "Present value. The current value of a series of payments" ;
1200 …. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic inter…
1232 Text [ en-US ] = "Present value. The current value of a series of payments" ;
1288 Text [ en-US ] = "Present value. The current value of a series of payments" ;
1320 …on the principal for an investment with regular payments and a constant interest rate for a given …
1360 Text [ en-US ] = "Present value. The current value of a series of payments" ;
1384 …Text [ en-US ] = "Repayment. Calculates the repayment amount for a period for an investment whereb…
1448 …Text [ en-US ] = "Cumulative Capital. Calculates the total amount of the repayment share in a peri…
1512 …erest. Calculates the total amount of the interest share in a period for an investment with a cons…
1576 …Text [ en-US ] = "Calculates the arithmetically declining value of an asset (depreciation) for a s…
1664 …Text [ en-US ] = "Calculates the depreciation of an asset for a specific period using the double-d…
1712 …Text [ en-US ] = "Factor. The factor for balance decline. F = 2 means a double declining balance f…
1720 …Text [ en-US ] = "Returns the real depreciation of an asset for a specified period using the fixed…
1776 …Text [ en-US ] = "Variable declining balance. Returns the declining balance depreciation for a par…
1848 Text [ en-US ] = "Calculates the annual net interest rate for a nominal interest rate." ;
1912 …Calculates the net present value of an investment based on a series of periodic payments and a dis…
1976 Text [ en-US ] = "Returns the modified internal rate of return for a series of investments." ;
2032 Text [ en-US ] = "Interest rate for a single amortization rate." ;
2144 Text [ en-US ] = "Returns TRUE if value is a reference." ;
2240 Text [ en-US ] = "Returns TRUE if the value carries a logical number format." ;
2336 Text [ en-US ] = "Returns TRUE if value is a number." ;
2360 Text [ en-US ] = "Returns TRUE if the cell is a formula cell." ;
2384 Text [ en-US ] = "Returns the formula of a formula cell." ;
2408 Text [ en-US ] = "Converts a value to a number." ;
2424 Text [ en-US ] = "The value to be interpreted as a number." ;
2448 …Text [ en-US ] = "Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 8 = f…
2472 Text [ en-US ] = "Determines information about address, formatting or contents of a cell." ;
2576 Text [ en-US ] = "Specifies a logical test to be performed." ;
2600 Text [ en-US ] = "The result of the function if the logical test returns a TRUE." ;
2689 Text [ en-US ] = "Absolute value of a number." ;
2713 Text [ en-US ] = "Returns a^b, base a raised to the power of exponent b." ;
2729 Text [ en-US ] = "The base a of the power a^b." ;
2737 Text [ en-US ] = "The exponent b of the power a^b." ;
2745 Text [ en-US ] = "Counts the blank cells in a specified range." ;
2849 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments to be multiplied and a result retu…
2938 …Text [ en-US ] = "Totals the values of cells in a range that meet multiple criteria in multiple ra…
3085 Text [ en-US ] = "Returns the square root of a number." ;
3109 Text [ en-US ] = "Returns a random number between 0 and 1." ;
3237 Text [ en-US ] = "Returns the arccosine of a number." ;
3261 Text [ en-US ] = "Returns the arcsine of a number." ;
3285 Text [ en-US ] = "Returns the inverse hyperbolic cosine of a number." ;
3309 Text [ en-US ] = "Returns the inverse hyperbolic sine of a number." ;
3333 Text [ en-US ] = "Returns the inverse cotangent of a number." ;
3357 Text [ en-US ] = "Returns the arctangent of a number." ;
3381 Text [ en-US ] = "Returns the inverse hyperbolic cotangent of a number." ;
3405 Text [ en-US ] = "Returns the inverse hyperbolic tangent of a number." ;
3429 Text [ en-US ] = "Returns the cosine of a number." ;
3453 Text [ en-US ] = "Returns the sine of a number." ;
3477 Text [ en-US ] = "Returns the cotangent of a number." ;
3501 Text [ en-US ] = "Returns the tangent of a number." ;
3525 Text [ en-US ] = "Returns the hyperbolic cosine of a number." ;
3549 Text [ en-US ] = "Returns the hyperbolic sine of a number." ;
3573 Text [ en-US ] = "Returns the hyperbolic cotangent of a number." ;
3597 Text [ en-US ] = "Returns the hyperbolic tangent of a number." ;
3701 Text [ en-US ] = "Return the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x)" ;
3725 Text [ en-US ] = "Return the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x)" ;
3749 Text [ en-US ] = "Converts a radian to degrees" ;
3765 Text [ en-US ] = "The angle in a radian" ;
3853 Text [ en-US ] = "Calculates the natural logarithm of a number." ;
3877 Text [ en-US ] = "Calculates the base-10 logarithm of a number." ;
3901 Text [ en-US ] = "Calculates the factorial of a number." ;
3925 Text [ en-US ] = "Calculates the remainder of a division." ;
3957 Text [ en-US ] = "Returns the algebraic sign of a number." ;
3981 Text [ en-US ] = "Calculates subtotals in a spreadsheet." ;
4013 Text [ en-US ] = "Rounds a number down to the nearest integer." ;
4037 Text [ en-US ] = "Truncates the decimal places of a number." ;
4069 Text [ en-US ] = "Rounds a number to a predefined accuracy." ;
4093 Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4101 Text [ en-US ] = "Rounds a number up to the predefined accuracy." ;
4125 Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4133 Text [ en-US ] = "Rounds a number down to a predefined accuracy." ;
4157 Text [ en-US ] = "The number of places down to which a number is to be rounded." ;
4165 …Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest even integer…
4189 …Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest odd integer.…
4213 Text [ en-US ] = "Rounds a number up to the nearest multiple of significance." ;
4245 …Text [ en-US ] = "If given and not equal to zero then rounded up according to amount when a negati…
4285 …Text [ en-US ] = "If given and not equal to zero then rounded down according to amount when a nega…
4445 Text [ en-US ] = "Returns the unitary square array of a certain size." ;
4593 Text [ en-US ] = "Returns a frequency distribution as a vertical array." ;
4721 Text [ en-US ] = "Calculates points along a regression line." ;
4865 Text [ en-US ] = "Returns the maximum value in a list of arguments." ;
4889 Text [ en-US ] = "Returns the maximum value in a list of arguments. Text is evaluated as Zero." ;
4913 Text [ en-US ] = "Returns the minimum value in a list of arguments." ;
4937 … Text [ en-US ] = "Returns the smallest value in a list of arguments. Text is evaluated as zero." ;
4961 Text [ en-US ] = "Calculates the variance based on a sample." ;
4977 …"Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
4985 Text [ en-US ] = "Returns the variance based on a sample. Text is evaluated as zero." ;
5001 …Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a b…
5025 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which represent a popula…
5049 Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments representing a population." ;
5057 Text [ en-US ] = "Calculates the standard deviation based on a sample." ;
5073 …"Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
5081 Text [ en-US ] = "Returns the standard deviation based on a sample. Text is evaluated as zero." ;
5097 …Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a b…
5121 …"Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
5145 Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments corresponding to a population." ;
5153 Text [ en-US ] = "Returns the average of a sample." ;
5169 …Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numeric arguments representing a population sa…
5177 Text [ en-US ] = "Returns the average value for a sample. Text is evaluated as zero." ;
5193 …Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a b…
5217 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample."…
5225 Text [ en-US ] = "Returns the average of the absolute deviations of a sample from the mean." ;
5241 Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numerical arguments representing a sample." ;
5249 Text [ en-US ] = "Returns the skewness of a distribution." ;
5265 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments portraying a sample of t…
5273 Text [ en-US ] = "Returns the kurtosis of a distribution." ;
5289 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments, representing a sample o…
5297 Text [ en-US ] = "Returns the geometric mean of a sample." ;
5313 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample."…
5321 Text [ en-US ] = "Returns the harmonic mean of a sample." ;
5337 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample."…
5345 Text [ en-US ] = "Returns the most common value in a sample." ;
5361 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample."…
5369 Text [ en-US ] = "Returns the median of a given sample." ;
5385 …Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample."…
5393 Text [ en-US ] = "Returns the alpha quantile of a sample." ;
5425 Text [ en-US ] = "Returns the quartile of a sample." ;
5457 Text [ en-US ] = "Returns the k-th largest value of a sample." ;
5489 Text [ en-US ] = "Returns the k-th smallest value of a sample." ;
5521 Text [ en-US ] = "Returns the percentage rank of a value in a sample." ;
5553 Text [ en-US ] = "Returns the ranking of a value in a sample." ;
5593 Text [ en-US ] = "Returns the mean of a sample without including the marginal values." ;
5673 Text [ en-US ] = "Returns the probability of a trial result using binomial distribution." ;
5697 Text [ en-US ] = "The individual probability of a trial result." ;
5721 Text [ en-US ] = "Values of the distribution function for a standard normal distribution." ;
5833 Text [ en-US ] = "The number of successes in a series of trials." ;
5849 Text [ en-US ] = "The success probability of a trial." ;
5897 Text [ en-US ] = "The success probability of a trial." ;
5929 Text [ en-US ] = "The success probability of a trial." ;
6896 Text [ en-US ] = "Converts a random variable to a normalized value." ;
6936 …Text [ en-US ] = "Returns the number of permutations for a given number of elements without repeti…
6968 …Text [ en-US ] = "Returns the number of permutations for a given number of objects (repetition all…
7000 Text [ en-US ] = "Returns a (1 alpha) confidence interval for a normal distribution." ;
7040 …-US ] = "Calculates the probability of observing a z-statistic greater than the one computed based…
7056 Text [ en-US ] = "The given sample, drawn from a normally distributed population." ;
7416 Text [ en-US ] = "Returns a value along a linear regression" ;
7456 Text [ en-US ] = "Returns the reference to a cell as text." ;
7512 Text [ en-US ] = "Returns the number of individual ranges that belong to a (multiple) range." ;
7528 Text [ en-US ] = "The reference to a (multiple) range." ;
7536 Text [ en-US ] = "Selects a value from a list of up to 30 value arguments." ;
7560 Text [ en-US ] = "Value 1, value 2,... The list of arguments from which a value is chosen." ;
7568 Text [ en-US ] = "Returns the internal column number of a reference." ;
7584 Text [ en-US ] = "The reference to a cell or a range." ;
7592 Text [ en-US ] = "Defines the internal row number of a reference." ;
7608 Text [ en-US ] = "The reference to a cell or a range." ;
7616 Text [ en-US ] = "Returns the internal sheet number of a reference or a string." ;
7632 Text [ en-US ] = "The reference to a cell or a range or the character string of a sheet name." ;
7664 Text [ en-US ] = "Returns the number of rows in a reference or array." ;
7688 …Text [ en-US ] = "Returns the number of sheets of a given reference. If no parameter has been ente…
7704 Text [ en-US ] = "The reference to a cell or a range." ;
7808 Text [ en-US ] = "Returns a reference to a cell from a defined range." ;
7824 Text [ en-US ] = "The reference to a (multiple) range." ;
7848 Text [ en-US ] = "The index of the subrange if referring to a multiple range." ;
7856 Text [ en-US ] = "Returns the contents of a cell that is referenced in text form." ;
7888 Text [ en-US ] = "Determines a value in a vector by comparison to values in another vector." ;
7928 Text [ en-US ] = "Defines a position in a array after comparing values." ;
7968 Text [ en-US ] = "Returns a reference which has been moved in relation to the starting point." ;
8024 Text [ en-US ] = "Returns a number corresponding to an error type" ;
8048 Text [ en-US ] = "Applies a Style to the formula cell." ;
8088 Text [ en-US ] = "Result of a DDE link." ;
8168 Text [ en-US ] = "Extracts value(s) from a pivot table." ;
8192 Text [ en-US ] = "A reference to a cell or range in the pivot table." ;
8208 Text [ en-US ] = "Converts a number to text (Baht)." ;
8280 Text [ en-US ] = "Returns a numeric code for the first character in a text string." ;
8304 Text [ en-US ] = "Converts a number to text in currency format." ;
8320 …Text [ en-US ] = "Value is a number, a reference to a cell containing a number or a formula that r…
8336 Text [ en-US ] = "Converts a code number into a character or letter." ;
8440 Text [ en-US ] = "Looks for a string of text within another (case sensitive)" ;
8464 Text [ en-US ] = "The text in which a search is to be made." ;
8504 Text [ en-US ] = "The text in which a search is to be made." ;
8616 Text [ en-US ] = "Converts text to a number." ;
8632 Text [ en-US ] = "The text to be converted to a number." ;
8640 Text [ en-US ] = "Converts a number to text according to a given format." ;
8672 Text [ en-US ] = "Returns a value if it is text, otherwise an empty string." ;
8696 Text [ en-US ] = "Replaces characters within a text string with a different text string." ;
8744 …Text [ en-US ] = "Formats a number with a fixed number of places after the decimal point and thous…
8784 Text [ en-US ] = "Calculates length of a text string." ;
8808 Text [ en-US ] = "Returns the first character or characters of a text." ;
8840 Text [ en-US ] = "Returns the last character or characters of a text." ;
8872 Text [ en-US ] = "Returns a partial text string of a text." ;
8912 Text [ en-US ] = "Repeats text a given number of times." ;
8944 Text [ en-US ] = "Substitutes new text for old text in a string." ;
8992 … Text [ en-US ] = "Converts a positive integer to text from a number system to the base defined." ;
9032 …Text [ en-US ] = "Converts a text of a specified number system to a positive integer in the base g…
9064 …Text [ en-US ] = "Converts a value according to a conversion table in the configuration (calc.xcu)…
9104 Text [ en-US ] = "Converts a number to a Roman numeral." ;
9120 Text [ en-US ] = "The number to be converted to a Roman numeral must be in the 0 - 3999 range." ;
9136 Text [ en-US ] = "Calculates the value of a Roman numeral." ;
9152 Text [ en-US ] = "The text that represents a Roman numeral." ;
9182 Text [ en-US ] = "Returns the numeric code for the first Unicode character in a text string." ;
9205 Text [ en-US ] = "Converts a code number into a Unicode character or letter." ;
9228 Text [ en-US ] = "Converts a value from one to another Euro currency." ;
9276 …Text [ en-US ] = "If given and >=3, the intermediate result of a triangular conversion is rounded …
9283 Text [ en-US ] = "Converts text to a number, in a locale-independent way." ;
9299 Text [ en-US ] = "The text to be converted to a number." ;
9314 Text [ en-US ] = "Calculates length of a text string, with DBCS" ;
9337 Text [ en-US ] = "Returns the last character or characters of a text, with DBCS" ;
9368 Text [ en-US ] = "Returns the first character or characters of a text, with DBCS" ;
9399 Text [ en-US ] = "Returns a partial text string of a text, with DBCS" ;