概览

在本例中,公式存在于“Total Due”列和最后一行中。可以直接在单元格中输入公式,例如: "SUM(C1:C3)",点击 Update 按钮进行公式更新。

 顾客发票总价应收款
0-3031-6061+
1正人资源10365¥503.2¥503.2¥0¥0
210507¥1,648.5¥0¥0¥1,648.5
310535¥395.2¥0¥395.2¥0
410573¥542.5¥542.5¥0¥0
5  ¥3,089.4¥1,045.7¥395.2¥1,648.5
  

以下是支持的函数:

日期和时间函数
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 COLUMNS HLOOKUP
INDEX LOOKUP 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


Spread 拥有强大的计算引擎,内置 300 多种公式。同时,您可以添加自定义公式和跨表单计算。

文档