Most Popular. New Releases. Desktop Enhancements. Networking Software. Trending from CNET. Home Windows Developer Tools. Download Now. Full Specifications. What's new in version 2. Date Added March 20, Operating Systems. NET Framework 2.
Total Downloads Downloads Last Week 0. Report Software. The source code may only be used within the original files. All source code provided by seller that is distributed with an application must be compiled or password protected to the extent that only the software developer s may obtain access to it. Non competion: you agree not to use the knowledge adquired from the source code in order to develop for yourself or any third party any program that is similar to or competitive with the Software.
You are not allowed to port the source code to other programming languages. You acknowledge and agree that the structure, sequence and organization of the Software are the valuable trade secrets of SmartXLS. Returns the inverse hyperbolic tangent of a number. Converts a number into a text representation with the given radix base. Returns a number rounded up, away from zero, to the nearest multiple of significance. Rounds a number up, to the nearest integer or to the nearest multiple of significance.
Rounds a number to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number if rounded up.
Returns the number of combinations for a given number of items. Returns the number of combinations with repetitions for a given number of items. Returns the cosine of the given angle. Returns the hyperbolic cosine of a number.
Returns the hyperbolic cotangent of a number. Returns the hyperbolic cosecant of an angle. Converts a text representation of a number in a given base into a decimal number.
Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers. Returns e 2. Returns the double factorial of a number. Rounds a number down, to the nearest integer or to the nearest multiple of significance.
Rounds a number to the nearest integeror to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. Returns the greatest common divisor of two or more integers.
Rounds a number down to the nearest integer. Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Returns the least common multiple of integers. Returns the natural base e logarithm of a number. Returns the logarithm of a number of the base you specify. Returns the base logarithm of a number. Returns the matrix determinant of an array. Returns the inverse matrix for the matrix stored in an array.
Returns the remainder of a division operation modulus. Returns a number rounded to the desired multiple. Rounds up if the remainder after dividing the number by the multiple is at least half the value of the multiple.
Returns the ratio of the factorial of the sum of the values to the product of the factorials. Returns a number rounded up away from zero to the nearest odd integer. Returns the approximate number 3. Returns the result of a specified number raised to a specified power. Multiplies all the numbers given as arguments and returns the product.
Returns the integer portion of a division. Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. Returns a random integer between the integers you specify.
Converts an Arabic numeral to Roman, as text. Round a number to a specified number of digits. Returns the hyperbolic secant of an angle. Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative.
Returns the hyperbolic sine of a number. Returns a subtotal in a list or database. Adds all the numbers in a range of cells. Adds the cells specified by a certain criteria. Adds the cells in a range that meet multiple criteria. Multiplies corresponding components in the given arrays, and returns the sum of those products.
Returns the sum of the squares of the arguments. Returns the sum of the difference of squares of corresponding values in two arrays. Returns the sum of the sum of squares of corresponding values in two arrays. Returns the sum of squares of differences of corresponding values in two arrays. Returns the tangent of the given angle. Returns the hyperbolic tangent of a number.
Truncates a number to an integer by removing the fractional part of a number. Returns the cumulative beta probability density function. Returns the inverse of the cumulative beta probability density function. Returns the individual term binomial distribution probability. Returns the test for independence of the characteristics in a table.
Joins several text strings into one text string. Returns the confidence interval for a population mean. Returns the covariance, the average of products of deviations, for each data point pair.
Returns the minimum number yields a binomial distribution less than or equal to the specified criteria. Returns the F probability distribution. Returns the inverse of the F probability distribution. Returns a number rounded down, toward zero, to the nearest multiple of significance. Calculates or predicts a future value by using existing values. Returns the inverse of the gamma cumulative distribution. Returns the hypergeometric distribution. Returns the inverse of the lognormal cumulative distribution function of x, where ln x is normally distributed with parameters mean and standard deviation.
Returns the cumulative lognormal distribution of x, where ln x is normally distributed with parameters mean and standard deviation. Returns the most frequently occuring, or repetitive, number in an array or range of data.
Returns the negative binomial distribution. Returns the normal cumulative distribution for the specified mean and standard deviation. Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Returns the standard normal cumulative distribution function. Returns the inverse of the standard normal cumulative distribution function. Returns the k-th percentile of values in a range.
Returns the rank of a value in a data set set as a percentage of the data set. Returns the rank of a number in a list of numbers. Estimates standard deviation based on a sample. Estimates standard deviation based on a sample assuming that the arguments represent the total population. Returns the percentage points probability for the student t-distribution, where a numeric value x is a calculated value of t for which the percentage points are to be computed.
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
The probability associated with t-test. Returns an estimate for the variance of a population based on a sample data set. Calculates variance based on the entire population. Returns the two-tailed P-value of a z-test. Retuns the average of the absolute deviations of data points from their mean.
Returns the average of the values in its list of arguments including text and logical values. Returns the average arithmetic mean of all the cells in a range that meet a given criteria. Returns the average arithmetic mean of all cells that meet multiple criteria.
Returns the beta cumulative distribution function. Returns the inverse of the cumulative distribution function for a specified beta distribution. Returns the probability of a trial result using a binomial distribution.
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. Returns the one-tailed probability of the chi-squared distribution. Returns the inverse of the left-tailed probability of the chi-squared distribution. Returns the inverse of the right-tailed probability of the chi-squared distribution. Returns the confidence interval for a population mean, using a Student's t distribution.
Returns the correlation coefficient between two data sets. Counts the number of cells that contain numbers including dates and formulas that evaluate to numbers within the list of arguments. Counts the number of cells that are not empty. Counts the empty cells in a specified range. Counts the number of cells in a range that meet a given criteria. Counts the number of cells within a range that meet multiple criteria. Returns covariance, the average of the products of paired deviations.
Returns the sample covariance, the average of the products deviations for each data point pair intwo data sets. Returns the sum of the squares of deviations of a data set from their sample mean. Returns the right-tailed F probability distribution degree of diversity for two data sets.
Returnd the inverse of the right-tailed F probability distribution. Returns the Fisher transformation at x. Returns the inverse of the Fisher transformation at y. Returns a future value based on existing values.
0コメント