我在这个版本的易表文件公式编辑器中发现很多函数只有简单的英文说明。不知道能不能用,这些函数怎么用?
Compare(string1, string2 [,caseSensitive])
Compares two text strings
Compound(principal, inerest, periods)
Calculates the compound amount, based on the
principal and interest rate per period over the
specified number of periods.
destr(string)
A String Function For Windows
destr2(string)
A String Function For Windows
DevSQ(list)
Returns the sum of squares of deviations.
Empty()
Returns an empty value.
Error(value)
Converts a value to error.
ExponDist(x, lambda, cumulative)
Returns the exponential distribution.
Fisher(x)
Returns the the Fisher transformation.
FisherInv(y)
Returns the inverse of the Fisher transformation.
Fixed(number [,precision [,commas]])
Formats a number as text with a fixed number of
decimals.
Geomean(list)
Returns the geometric mean.
Harmean(list)
Returns the harmonic mean.
HypGeomDist(sample, n_sample, population,
n_population)
Returns the hypergeometric distribution.
IsError(value)
Tests value for error.
Kurt(list)
Returns the kurtosis of list.
LogNormDist(x, mean,standard_dev)
Returns the cumulative lognormal distribution of x.
Multinomial(list)
Returns the multinomial of a set of numbers.
NegBinomDist(number_f, number_s, probability_s)
Returns the negative binomial distribution.
NormDist(x, mean, stdev)
Returns the normal cumulative distribution.
NormSDist(z)
Returns the standard normal cumulative distribution.
Permut(n, m)
Returns the number of permutations for a number of
things.
Poisson(x, mean, cumulative)
Returns the Poisson distribution.
Proper(text)
Capitalizes the first letter in each word of a text
value.
RenameCol(Col,ColName)
0
SetResolution(X,Y)
0
SKEW(list)
Returns the skewness of a distribution.
Standardize(x, mean, stdev)
Returns a normalized value.
Stdev(list)
Estimates standard deviation based on a sample.
StdevP(list)
Calculates standard deviation based on the entire
population.
VarP(list)
Calculates variance based on the entire population.
Weibull(x, alpha, beta, cumulative)
Returns the Weibull distribution.
Workday(start_date, days [,list_holidays])
Returns the date before or after a specified number
of workdays.