5201 Text files (*.txt)\n*.txt\nAll files (*.*)\n*.*\n
5202 Import text
5203 Options
5204 The selected sheets will be permanently deleted. Continue?
5205 Format Brush
5206 User dictionary selection
5250 (New list)
5251 January
5252 February
5253 March
5254 April
5255 May
5256 June
5257 July
5258 August
5259 September
5260 October
5261 November
5262 December
5263 Monday
5264 Tuesday
5265 Wednesday
5266 Thursday
5267 Friday
5268 Saturday
5269 Sunday
5270 Mon
5271 Tue
5272 Wed
5273 Thu
5274 Fri
5275 Sat
5276 Sun
5277 I
5278 II
5279 III
5280 IV
5281 V
5282 VI
5283 VII
5284 VIII
5285 IX
5286 X
5287 XI
5288 XII
5500 Counts the number of numbers within the list.
5501 If a condition is true, it returns IfTrueValue, in opposite case it returns IfFalseValue.
5502 Returns TRUE if value is !!chNe error value .
5503 Returns TRUE if value is error value .
5504 Returns sum of all numbers within the list.
5505 Returns arithmetic mean of all numbers within the list.
5506 Returns the smallest number within the list.
5507 Returns the largest number within the list.
5508 Returns the row number of a cell reference.
5509 Returns the column number of a cell reference.
5510 Returns error value !!chNe (value not available).
5511 Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values).
5512 Estimates standard deviation based on a sample (ignores texts and logical values).
5513 Rounds a number to the specified number of decimals and returns the result as text with or without commas.
5514 Returns the sine of an angle.
5515 Returns the cosine of an angle.
5516 Returns the tangent of an angle.
5517 Returns the arctangent of a number. The result is in radians in the range -Pi/2 up to Pi/2.
5518 Returns the value of Pi (3.1415926535898).
5519 Returns square root of a number.
5520 Returns basis of natural logarithms (e) raised to the power of given number.
5521 Returns the natural logarithm of a number.
5522 Returns the base-10 logarithm of a number.
5523 Returns the absolute value of a number.
5524 Returns integer part of a number. Rounds a number down to the nearest integer.
5525 Returns 1, if the number is positive. Returns 0, if the number is zero. Returns -1, if the number is negative.
5526 Rounds a number to a specified number of digits.
5527 Repeats text a given number of times.
5528 Returns a specific number of characters from a text string starting at the position you specify.
5529 Returns the number of characters in a text string.
5530 Converts a text string that represents a number to a number.
5531 Returns the logical value TRUE.
5532 Returns the logical value FALSE.
5533 Returns TRUE if all its arguments are TRUE. Returns FALSE if any argument is FALSE.
5534 Returns TRUE if any argument is TRUE. Returns FALSE if all arguments are FALSE.
5535 Reverses the logic of its argument. Returns TRUE if argument is FALSE. Returns FALSE if argument is TRUE .
5536 Returns the remainder after a number is divided by a divisor.
5537 Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify.
5538 Adds the numbers in the field (column) of records in the database that match the conditions you specify.
5539 Averages the values in the field (column) of records in the database that match the conditions you specify.
5540 Returns the smallest number in the field (column) of records in the database that match the conditions you specify.
5541 Returns the largest number in the field (column) of records in the database that match the conditions you specify.
5542 Estimates the standard deviation based on numbers in the field (column) of records in the database that match the conditions you specify.
5543 Estimates variance based on a sample (ignores texts and logical values).
5544 Estimates variance based on a sample in the field (column) of records in the database that match the conditions you specify.
5545 Returns present value of an investment (the total amount that a series of future payments is worth now).
5546 Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
5547 Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
5548 Calculates the payment for a loan.
5549 Returns the interest rate per period of a loan or annuity.
5550 Returns the internal rate of return for a series of periodic cash flows. It considers both cost of investment and interest on reinvestment of cash.
5551 Returns the internal rate of return for a series of cash flows.
5552 Returns a random number (greater than or equal to 0 and less than 1). It changes on each workbook recalculation.
5553 Returns the number that represents specified date.
5554 Returns the number that represents specified time.
5555 Returns the day of the month (a number from 1 to 31) for specified date.
5556 Returns the month, an integer from 1 to 12, for specified date.
5557 Returns the year (e.g. 2000) for specified date.
5558 Returns a number from 1 to 7 identifying the day of the week based on a given number that represents a date.
5559 Returns the hour (0..23) corresponding to specified time.
5560 Returns the minute (0..59) corresponding to specified time.
5561 Returns the second (0..59) corresponding to specified time.
5562 Returns current date and time.
5563 Returns the number of rows in a range.
5564 Returns the number of columns in a range.
5565 Returns a reference to a range shifted by specified number of rows and columns.
5566 Returns a number indicating the data type of a value (number = 1; text = 2; logical value = 4, error value = 16).
5567 Returns the arctangent of the specified x- and y- coordinates. The result is in radians between [-Pi and Pi).
5568 Returns the arcsine of a number. The result is in radians in the range -Pi/2 to Pi/2.
5569 Returns the arccosine of a number. The result is in radians in the range 0 to Pi.
5570 Looks for a value in the top row of a range and returns the value in the same column from a row you specify.
5571 Searches for a value in the leftmost column of a range and returns a value in the same row from a column you specify.
5572 Returns TRUE if value is a reference.
5573 Returns the logarithm of a number to the base you specify .
5574 Returns the character specified by the code number from the character set for your computer.
5575 Converts all characters in a text string to lower case.
5576 Converts all characters in a text string to upper case.
5577 Capitalizes the first letter in each word of a text string and converts all other letters to lowercase letters.
5578 Returns the first n characters in a text string.
5579 Returns the last n characters in a text string.
5580 Returns TRUE if the text strings are the same (case-sensitive).
5581 Removes all spaces from a text string except for single spaces between words.
5582 Replaces n characters of a text string starting from specified position with a new text.
5583 Replaces OldText with NewText in a text string.
5584 Returns a numeric code for the first character in a text string in the character set used by your computer.
5585 Returns the number of the starting position of occurrence of a character or text string (case-sensitive).
5586 Returns TRUE if value is any error value with the exception !!chNe.
5587 Returns TRUE if value is text .
5588 Returns TRUE if value is number.
5589 Returns TRUE if value refers to empty cell.
5590 Returns the text referred to by value.
5591 Returns a value converted to a number. Number and date are converted to number, TRUE to 1 and anything else to 0.
5592 Converts text string representing a date to a number that represents a date.
5593 Converts text string representing time to a number that represents time.
5594 Returns the straight-line depreciation of an asset for one period.
5595 Returns the sum-of-years' digits depreciation of an asset for a specified period.
5596 Returns depreciation of an asset for a specified period (including the incomplete ones) using the depreciation method you specify.
5597 Removes all nonprintable characters from a text string.
5598 Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate.
5599 Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.
5600 Counts the number of nonblank cells within the list of arguments.
5601 Returns product of all numbers within the list.
5602 Returns factorial of a number (i.e. 1*2*3...*number).
5604 Returns TRUE if value is not text .
5605 Calculates standard deviation based on the entire population (ignores texts and logical values).
5606 Calculates variance based on the entire population (ignores texts and logical values).
5607 Calculates the standard deviation based on the entire population in the field (column) of records in the database that match the conditions you specify.
5608 Calculates variance based on the entire population in the field (column) of records in the database that match the conditions you specify.
5609 Truncates a number to an integer by removing the decimal or fractional part of the number.
5610 Returns TRUE if value is a logical value.
5611 Counts the nonblank cells in the field (column) of records in the database that match the conditions you specify.
5612 Rounds a number up, away from zero.
5613 Rounds a number down, toward zero.
5614 Returns the rank of a number in a list of numbers. Its size relative to other values in the list.
5615 Creates a cell reference from specified row and column numbers.
5616 Returns today's date.
5617 Returns the median, or the number in the middle of the set of given numbers.
5618 Multiplies corresponding numeric components in given ranges and returns the sum of those products.
5619 Returns the hyperbolic sine of a number.
5620 Returns the hyperbolic cosine of a number.
5621 Returns the hyperbolic tangent of a number.
5622 Returns the hyperbolic arcsine of a number.
5623 Returns the hyperbolic arccosine of a number.
5624 Returns the hyperbolic arctangent of a number.
5625 Extracts from a database a single record that matches the conditions you specify.
5626 Returns the average of the absolute deviations of data points from their mean.
5627 Returns the cumulative beta probability density function.
5628 Returns the natural logarithm of the gamma function.
5629 Returns the inverse of the cumulative beta probability density function.
5630 Returns the individual term binomial distribution probability.
5631 Returns the one-tailed probability of the chi-squared distribution.
5632 Returns the inverse of the one-tailed probability of the chi-squared distribution.
5633 Returns the number of combinations for a given number of items.
5634 Returns the confidence interval for a population mean.
5635 Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
5636 Rounds a number up to the nearest even integer.
5637 Returns the exponential distribution value.
5638 Returns the F probability distribution for two data sets.
5639 Returns the inverse of the F probability distribution.
5640 Returns the Fisher transformation value.
5641 Returns the inverse of the Fisher transformation.
5642 Rounds a number down, toward zero, to the nearest multiple of significance.
5643 Returns the gamma distribution value.
5644 Returns the inverse of the gamma cumulative distribution.
5645 Rounds a number up, to the nearest integer or to the nearest multiple of significance.
5646 Returns the hypergeometric distribution.
5647 Returns the cumulative lognormal distribution of x.
5648 Returns the inverse of the lognormal cumulative distribution function of x.
5649 Returns the negative binomial distribution.
5650 Returns the normal cumulative distribution for the specified mean and standard deviation.
5651 Returns the standard normal cumulative distribution (has a mean of zero and standard deviation of one).
5652 Returns the inverse of the normal cumulative distribution function (Normdist).
5653 Returns the inverse of the standard normal cumulative distribution function (Normsdist).
5654 Returns a normalized value from a distribution characterized by mean and standard deviation.
5655 Rounds a number up to the nearest odd integer.
5656 Returns the number of permutations for a given number of objects that can be selected from the total objects.
5657 Returns the Poisson distribution.
5658 Returns the Student's t-distribution.
5659 Returns the Weibull distribution.
5660 Calculates the differences of corresponding values in two ranges and returns the sum of squares of the differences.
5661 Calculates the difference between the squares of corresponding numbers in two ranges and then returns the sum of squares of the differences.
5662 Calculates the sum of the squares of corresponding numbers in two ranges and then returns the sum total of the sums.
5663 Returns the test for independence (the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom).
5664 Returns the correlation coefficient between two data sets.
5665 Returns covariance.
5666 Predicts a future value along a linear trend.
5667 Returns the result of an F-test.
5668 Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted through the known x-values and y-values.
5669 Returns the Pearson product moment correlation coefficient r.
5670 Returns the square of the Pearson product moment correlation coefficient through the given data points.
5671 Returns the standard error of the predicted y-value for each x in a regression.
5672 Returns the slope of the linear regression line through the given data points.
5673 Returns the probability that values in a range are between two limits [LowerLimit..UpperLimit).
5674 Returns the sum of squares of deviations of data points from their sample mean.
5675 Returns the geometric mean of a range of positive numeric data.
5676 Returns the harmonic mean of a data set of positive numbers.
5677 Returns the sum of squares of the arguments.
5678 Returns the kurtosis of a data set.
5679 Returns the skewness of a distribution.
5680 Returns a value of a z-test.
5681 Returns the n-th largest value in a data set.
5682 Returns the n-th smallest value in a data set.
5683 Returns the n-th percentile.
5684 Returns the rank of a value in a data set as a percentage of the data set.
5685 Returns the most frequently occurring, or repetitive, value in a range of data.
5686 Returns the mean of the interior portion of a set of data values.
5687 Returns the inverse of the Student's t-distribution.
5688 Joins several text strings into one text string.
5689 Returns the result of a number raised to a power.
5690 Converts degrees to radians.
5691 Converts radians to degrees.
5692 Returns a subtotal in a sheet.
5693 Adds the cells specified by a given condition or criteria.
5694 Counts the number of cells within a range that meet the given condition.
5695 Counts empty cells in a specified range of cells.
5696 Returns the average of all values in a set of values (TRUE is 1, FALSE and texts are 0).
5697 Returns the largest value in a set of values (TRUE is 1, FALSE and texts are 0).
5698 Returns the smallest value in a set of values (TRUE is 1, FALSE and texts are 0).
5699 Calculates standard deviation based on an entire population (TRUE is 1, FALSE and texts are 0).
5700 Calculates variance based on an entire population (TRUE is 1, FALSE and texts are 0).
5701 Estimates standard deviation based on a sample (TRUE is 1, FALSE and texts are 0).
5702 Estimates variance based on a sample (TRUE is 1, FALSE and texts are 0).
5703
5704 Finds the value in a row or column (Vector1) and returns the corresponding value from a row or column (Vector2).
5705 Returns the relative position of a value in a specified range.
