易表在线答疑技术与交流用户社区 → 适合易表二次开发的朋友,易表.net电脑报版集成整合程序10月23日更新


  共有25100人关注过本帖树形打印复制链接

主题:适合易表二次开发的朋友,易表.net电脑报版集成整合程序10月23日更新

帅哥哟,离线,有人找我吗?
老宋
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游侠 帖子:215 积分:148 威望:0 精华:0 注册:2007/7/18 15:48:00
  发帖心情 Post By:2009/10/21 15:33:00 [显示全部帖子]

我在这个版本的易表文件公式编辑器中发现很多函数只有简单的英文说明。不知道能不能用,这些函数怎么用?
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.


 回到顶部