Country  china

海量各领域函数和自定义公式,轻松实现各种运算

海量各领域函数:支持300多种内置函数,包括日期、时间函数、工程计算函数、财务计算函数、逻辑函数、数学和三角函数、统计函数、文本函数等。

自定义公式:支持通过内置函数和运算符来自定义公式。

灵活的引用方式:公式计算引擎支持单元格的引用、表单的交叉引用、循环引用、函数嵌套等。

数据库函数
DAVERAGE DCOUNT DCOUNTA DGET
DMAX DMIN DPRODUCT DSTDEV
DSTDEVP DSUM DVAR DVARP
日期和时间函数
DATE DATEDIF DATEVALUE DAY
DAYS360 EDATE EOMONTH HOUR
MINUTE MONTH NETWORKDAYS NOW
SECOND TIME TIMEVALUE TODAY
WEEKDAY WEEKNUM WORKDAY YEAR
YEARFRAC      
工程计算函数
BESSELI BESSELJ BESSELK BESSELY
BIN2DEC BIN2HEX BIN2OCT COMPLEX
CONVERT DEC2BIN DEC2HEX DEC2OCT
DELTA ERF ERFC GESTEP
HEX2BIN HEX2DEC HEX2OCT IMABS
IMAGINARY IMARGUMENT IMCONJUGATE IMCOS
IMDIV IMEXP IMLN IMLOG10
IMLOG2 IMPOWER IMPRODUCT IMREAL
IMSIN IMSQRT IMSUB IMSUM
OCT2BIN OCT2DEC OCT2HEX  
财务和金融函数
ACCRINT ACCRINTM AMORDEGRC AMORLINC
COUPDAYS COUPDAYBS COUPDAYSNC COUPNCD
COUPNUM COUPPCD CUMIPMT CUMPRINC
DB DDB DISC DOLLAR
DOLLARDE DOLLARFR DURATION EFFECT
EURO EUROCONVERT FV FVSCHEDULE
INTRATE IPMT IRR ISPMT
MDURATION MIRR NOMINAL NPER
NPV ODDFPRICE ODDFYIELD ODDLPRICE
ODDLYIELD PMT PPMT PRICE
PRICEDISC PRICEMAT PV RATE
RECEIVED SLN SYD TBILLEQ
TBILLPRICE TBILLYIELD VDB XIRR
XNPV YIELD YIELDDISC YIELDMAT
信息函数
COUNTBLANK ERRORTYPE ISBLANK ISERR
ISERROR ISEVEN ISLOGICAL ISNA
ISNONTEXT ISNUMBER ISODD ISREF
ISTEXT N NA TYPE
逻辑函数
AND FALSE IF NOT
OR TRUE    
查找函数
ADDRESS CHOOSE COLUMN COLUMNS
HLOOKUP INDEX LOOKUP OFFSET
ROW ROWS TRANSPOSE VLOOKUP
数学和三角函数
ABS ACOS ACOSH ASIN
ASINH ATAN ATAN2 ATANH
CEILING COMBIN COS COSH
COUNTIF DEGREES EVEN EXP
FACT FACTDOUBLE FLOOR GCD
INT LCM LN LOG
LOG10 MDETERM MINVERSE MMULT
MOD MROUND MULTINOMIAL ODD
PI POWER PRODUCT QUOTIENT
RADIANS RAND RANDBETWEEN ROMAN
ROUND ROUNDDOWN ROUNDUP SERIESSUM
SIGN SIN SINH SQRT
SQRTPI SUBTOTAL SUM SUMIF
SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2
SUMXMY2 TAN TANH TRUNC
统计函数
AVEDEV AVERAGE AVERAGEA BETADIST
BETAINV BINOMDIST CHIDIST CHIINV
CHITEST CONFIDENCE CORREL COUNT
COUNTA COVAR CRITBINOM DEVSQ
EXPONDIST FDIST FINV FISHER
FISHERINV FORECAST FREQUENCY FTEST
GAMMADIST GAMMAINV GAMMALN GEOMEAN
GROWTH HARMEAN HYPGEOMDIST INTERCEPT
KURT LARGE LINEST LOGEST
LOGINV LOGNORMDIST MAX MAXA
MEDIAN MIN MINA MODE
NEGBINOMDIST NORMDIST NORMINV NORMSDIST
NORMSINV PEARSON PERCENTILE PERCENTRANK
PERMUT POISSON PROB QUARTILE
RANK RSQ SKEW SLOPE
SMALL STANDARDIZE STDEV STDEVA
STDEVP STDEVPA STEYX TDIST
TINV TREND TRIMMEAN TTEST
VAR VARA VARP VARPA
WEIBULL ZTEST    
文本函数
CHAR CLEAN CODE CONCATENATE
DOLLAR EXACT FIND FIXED
LEFT LEN LOWER MID
PROPER REPLACE REPT RIGHT
SUBSTITUTE T TRIM UPPER
VALUE      

现在就开始试用吧!

30天产品试用下载。在您下载试用之后,我们的技术支持工程师会全力帮助您同步解决遇到的产品问题。