根据Microsoft Excel官方文档，下表列出了Smart Tables for Confluence中包含的所有公式


公式作用
1ABSMath and trigonometry: Returns the absolute value of a number
2ACCRINTFinancial: Returns the accrued interest for a security that pays periodic interest
3ACOSMath and trigonometry: Returns the arccosine of a number
4ACOSHMath and trigonometry: Returns the inverse hyperbolic cosine of a number
5ACOTMath and trigonometry: Returns the arccotangent of a number
6ACOTHMath and trigonometry: Returns the hyperbolic arccotangent of a number
7AGGREGATEMath and trigonometry: Returns an aggregate in a list or database
8ANDLogical: Returns TRUE if all of its arguments are TRUE
9ARABICMath and trigonometry: Converts a Roman number to Arabic, as a number
10ASINMath and trigonometry: Returns the arcsine of a number
11ASINHMath and trigonometry: Returns the inverse hyperbolic sine of a number
12ATANMath and trigonometry: Returns the arctangent of a number
13ATAN2Math and trigonometry: Returns the arctangent from x- and y-coordinates
14ATANHMath and trigonometry: Returns the inverse hyperbolic tangent of a number
15AVEDEVStatistical: Returns the average of the absolute deviations of data points from their mean
16AVERAGEStatistical: Returns the average of its arguments
17AVERAGEAStatistical: Returns the average of its arguments, including numbers, text, and logical values
18AVERAGEIFStatistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
19AVERAGEIFSStatistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.
20BASEMath and trigonometry: Converts a number into a text representation with the given radix (base)
21BESSELIEngineering: Returns the modified Bessel function In(x)
22BESSELJEngineering: Returns the Bessel function Jn(x)
23BESSELKEngineering: Returns the modified Bessel function Kn(x)
24BESSELYEngineering: Returns the Bessel function Yn(x)
25BETA.DISTStatistical: Returns the beta cumulative distribution function
26BETA.INVStatistical: Returns the inverse of the cumulative distribution function for a specified beta distribution
27BETADISTCompatibility: Returns the beta cumulative distribution function
28BETAINVCompatibility: Returns the inverse of the cumulative distribution function for a specified beta distribution
29BIN2DECEngineering: Converts a binary number to decimal
30BIN2HEXEngineering: Converts a binary number to hexadecimal
31BIN2OCTEngineering: Converts a binary number to octal
32BINOM.DISTStatistical: Returns the individual term binomial distribution probability
33BINOM.DIST.RANGEStatistical: Returns the probability of a trial result using a binomial distribution
34BINOM.INVStatistical: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
35BINOMDISTCompatibility: Returns the individual term binomial distribution probability
36BITANDEngineering: Returns a 'Bitwise And' of two numbers
37BITLSHIFTEngineering: Returns a value number shifted left by shift_amount bits
38BITOREngineering: Returns a bitwise OR of 2 numbers
39BITRSHIFTEngineering: Returns a value number shifted right by shift_amount bits
40BITXOREngineering: Returns a bitwise 'Exclusive Or' of two numbers
41CEILINGMath and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance
42CHARText: Returns the character specified by the code number
43CHISQ.DISTStatistical: Returns the cumulative beta probability density function
44CHISQ.DIST.RTStatistical: Returns the one-tailed probability of the chi-squared distribution
45CHISQ.INVStatistical: Returns the cumulative beta probability density function
46CHISQ.INV.RTStatistical: Returns the inverse of the one-tailed probability of the chi-squared distribution
47CHOOSELookup and reference: Chooses a value from a list of values
48CHOOSELookup and reference: Chooses a value from a list of values
49CLEANText: Removes all nonprintable characters from text
50CODEText: Returns a numeric code for the first character in a text string
51COLUMNLookup and reference: Returns the column number of a reference
52COLUMNSLookup and reference: Returns the number of columns in a reference
53COMBINMath and trigonometry: Returns the number of combinations for a given number of objects
54COMBINAMath and trigonometry:
Returns the number of combinations with repetitions for a given number of items
55COMPLEXEngineering: Converts real and imaginary coefficients into a complex number
56CONCATENATEText: Joins several text items into one text item
57CONFIDENCECompatibility: Returns the confidence interval for a population mean
58CONFIDENCE.NORMStatistical: Returns the confidence interval for a population mean
59CONFIDENCE.TStatistical: Returns the confidence interval for a population mean, using a Student's t distribution
60CONVERTEngineering: Converts a number from one measurement system to another
61CORRELStatistical: Returns the correlation coefficient between two data sets
62COSMath and trigonometry: Returns the cosine of a number
63COSHMath and trigonometry: Returns the hyperbolic cosine of a number
64COTMath and trigonometry: Returns the hyperbolic cosine of a number
65COTHMath and trigonometry: Returns the cotangent of an angle
66COUNTStatistical: Counts how many numbers are in the list of arguments
67COUNTAStatistical: Counts how many values are in the list of arguments
68COUNTBLANKStatistical: Counts the number of blank cells within a range
69COUNTIFStatistical: Counts the number of cells within a range that meet the given criteria
70COUNTIFSStatistical: Counts the number of cells within a range that meet multiple criteria
71COVARIANCE.PStatistical: Returns covariance, the average of the products of paired deviations
72COVARIANCE.SStatistical: Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
73CSCMath and trigonometry: Returns the cosecant of an angle
74CSCHMath and trigonometry: Returns the hyperbolic cosecant of an angle
75CUMIPMTFinancial: Returns the cumulative interest paid between two periods
76CUMPRINCFinancial: Returns the cumulative principal paid on a loan between two periods
77DATEVALUEDate and time: Converts a date in the form of text to a serial number
78DAYDate and time: Converts a serial number to a day of the month
79DAYSDate and time: Returns the number of days between two dates
80DAYS360Date and time: Calculates the number of days between two dates based on a 360-day year
81DBFinancial: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
82DDBFinancial: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
83DEC2BINEngineering: Converts a decimal number to binary
84DEC2HEXEngineering: Converts a decimal number to hexadecimal
85DEC2OCTEngineering: Converts a decimal number to octal
86DECIMALMath and trigonometry: Converts a text representation of a number in a given base into a decimal number
87DEGREESMath and trigonometry: Converts radians to degrees
88DELTAEngineering: Tests whether two values are equal
89DEVSQStatistical: Returns the sum of squares of deviations
90DOLLARDEFinancial: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
91DOLLARFRFinancial: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
92EFFECTFinancial: Returns the effective annual interest rate
93EOMONTHDate and time: Returns the serial number of the last day of the month before or after a specified number of months
94ERFEngineering: Returns the error function
95ERFCEngineering: Returns the complementary error function
96EVENMath and trigonometry: Rounds a number up to the nearest even integer
97EXACTText: Checks to see if two text values are identical
98EXPMath and trigonometry: Returns e raised to the power of a given number
99EXPON.DISTStatistical: Returns the exponential distribution
100EXPONDISTCompatibility: Returns the exponential distribution
101F.DISTStatistical: Returns the F probability distribution
102F.DIST.RTStatistical: Returns the F probability distribution
103F.INVStatistical: Returns the inverse of the F probability distribution
104F.INV.RTStatistical: Returns the inverse of the F probability distribution
105FACTDOUBLEMath and trigonometry: Returns the double factorial of a number
106FALSELogical: Returns the logical value FALSE
107FDISTCompatibility: Returns the F probability distribution
108FINVStatistical: Returns the inverse of the F probability distribution
109FISHERStatistical: Returns the Fisher transformation
110FISHERINVStatistical: Returns the inverse of the Fisher transformation
111FLOORCompatibility: Rounds a number down, toward zero
112FORECASTStatistical: Returns a value along a linear trend
113FREQUENCYStatistical: Returns a frequency distribution as a vertical array
114FVFinancial: Returns the future value of an investment
115FVSCHEDULEFinancial: Returns the future value of an initial principal after applying a series of compound interest rates
116GAMMA.DISTStatistical: Returns the gamma distribution
117GAMMA.INVStatistical: Returns the inverse of the gamma cumulative distribution
118GAMMADISTCompatibility: Returns the gamma distribution
119GAMMAINVCompatibility: Returns the inverse of the gamma cumulative distribution
120GAMMALNStatistical: Returns the natural logarithm of the gamma function, Γ(x)
121GAMMALN.PRECISEStatistical: Returns the natural logarithm of the gamma function, Γ(x)
122GAUSSStatistical: Returns 0.5 less than the standard normal cumulative distribution
123GCDMath and trigonometry: Returns the greatest common divisor
124GEOMEANStatistical: Returns the geometric mean
125GESTEPEngineering: Tests whether a number is greater than a threshold value
126GROWTHStatistical: Returns values along an exponential trend
127HEX2BINEngineering: Converts a hexadecimal number to binary
128HEX2DECEngineering: Converts a hexadecimal number to decimal
129HEX2OCTEngineering: Converts a hexadecimal number to octal
130HOURDate and time: Converts a serial number to an hour
131HYPGEOM.DISTStatistical: Returns the hypergeometric distribution
132HYPGEOMDISTCompatibility: Returns the hypergeometric distribution
133IMABSEngineering: Returns the absolute value (modulus) of a complex number
134IMAGINARYEngineering: Returns the imaginary coefficient of a complex number
135IMARGUMENTEngineering: Returns the argument theta, an angle expressed in radians
136IMCONJUGATEEngineering: Returns the complex conjugate of a complex number
137IMCOSEngineering: Returns the cosine of a complex number
138IMCOSHEngineering: Returns the hyperbolic cosine of a complex number
139IMCOTEngineering: Returns the cotangent of a complex number
140IMCSCEngineering: Returns the cosecant of a complex number
141IMCSCHEngineering: Returns the hyperbolic cosecant of a complex number
142IMDIVEngineering: Returns the quotient of two complex numbers
143IMEXPEngineering: Returns the exponential of a complex number
144IMLNEngineering: Returns the natural logarithm of a complex number
145IMLOG10Engineering: Returns the base-10 logarithm of a complex number
146IMLOG2Engineering: Returns the base-2 logarithm of a complex number
147IMPOWEREngineering: Returns a complex number raised to an integer power
148IMPRODUCTEngineering: Returns the product of complex numbers
149IMREALEngineering: Returns the real coefficient of a complex number
150IMSECEngineering: Returns the secant of a complex number
151IMSECHEngineering: Returns the hyperbolic secant of a complex number
152IMSINEngineering: Returns the sine of a complex number
153IMSINHEngineering: Returns the hyperbolic sine of a complex number
154IMSQRTEngineering: Returns the square root of a complex number
155IMSUBEngineering: Returns the difference between two complex numbers
156IMSUMEngineering: Returns the sum of complex numbers
157IMTANEngineering: Returns the tangent of a complex number
158INTMath and trigonometry: Rounds a number down to the nearest integer
159INTERCEPTStatistical: Returns the intercept of the linear regression line
160IPMTFinancial: Returns the interest payment for an investment for a given period
161IRRFinancial: Returns the internal rate of return for a series of cash flows
162ISBLANKInformation: Returns TRUE if the value is blank
163ISEVENInformation: Returns TRUE if the number is even
164ISLOGICALInformation: Returns TRUE if the value is a logical value
165ISNONTEXTInformation: Returns TRUE if the value is not text
166ISNUMBERInformation: Returns TRUE if the value is a number
167ISODDInformation: Returns TRUE if the number is odd
168ISODDInformation: Returns TRUE if the number is odd
169ISOWEEKNUMDate and time: Returns the number of the ISO week number of the year for a given date
170ISTEXTInformation: Returns TRUE if the value is text
171LCMMath and trigonometry: Returns the least common multiple
172LEFTText: Returns the leftmost characters from a text value
173LENText: Returns the number of characters in a text string
174LINESTStatistical: Returns the parameters of a linear trend
175LNMath and trigonometry: Returns the natural logarithm of a number
176LOGMath and trigonometry: Returns the logarithm of a number to a specified base
177LOG10Math and trigonometry: Returns the base-10 logarithm of a number
178LOGESTStatistical: Returns the parameters of an exponential trend
179LOGNORM.DISTStatistical: Returns the cumulative lognormal distribution
180LOGNORM.INVStatistical: Returns the inverse of the lognormal cumulative distribution
181LOGNORMDISTCompatibility: Returns the cumulative lognormal distribution
182LOWERText: Converts text to lowercase
183MAXStatistical: Returns the maximum value in a list of arguments
184MAXAStatistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values
185MEDIANStatistical: Returns the median of the given numbers
186MINStatistical: Returns the minimum value in a list of arguments
187MINAStatistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values
188MINUTEDate and time: Converts a serial number to a minute
189MIRRFinancial: Returns the internal rate of return where positive and negative cash flows are financed at different rates
190MODMath and trigonometry: Returns the remainder from division
191MODE.MULTStatistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
192MODE.SNGLStatistical: Returns the most common value in a data set
193MONTHDate and time: Converts a serial number to a month
194MROUNDMath and trigonometry: Returns a number rounded to the desired multiple
195MULTINOMIALMath and trigonometry: Returns the multinomial of a set of numbers
196NEGBINOM.DISTStatistical: Returns the negative binomial distribution
197NEGBINOMDISTCompatibility: Returns the negative binomial distribution
198NETWORKDAYSDate and time: Returns the number of whole workdays between two dates
199NOMINALFinancial: Returns the annual nominal interest rate
200NORM.DISTStatistical: Returns the normal cumulative distribution
201NORM.INVCompatibility: Returns the inverse of the normal cumulative distribution
202NORM.S.DISTStatistical: Returns the standard normal cumulative distribution
203NORM.S.INVStatistical: Returns the inverse of the standard normal cumulative distribution
204NORMDISTCompatibility: Returns the normal cumulative distribution
205NORMINVStatistical: Returns the inverse of the normal cumulative distribution
206NORMSDISTCompatibility: Returns the standard normal cumulative distribution
207NORMSINVCompatibility: Returns the inverse of the standard normal cumulative distribution
208NOTLogical: Reverses the logic of its argument
209NOWDate and time: Returns the serial number of the current date and time
210NPERFinancial: Returns the number of periods for an investment
211NPVFinancial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
212OCT2DECEngineering: Converts an octal number to decimal
213OCT2HEXEngineering: Converts an octal number to hexadecimal
214ODDMath and trigonometry: Rounds a number up to the nearest odd integer
215ORLogical: Returns TRUE if any argument is TRUE
216PEARSONStatistical: Returns the Pearson product moment correlation coefficient
217PERMUTStatistical: Returns the number of permutations for a given number of objects
218PERMUTATIONAStatistical: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
219PHIStatistical: Returns the value of the density function for a standard normal distribution
220PIMath and trigonometry: Returns the value of pi
221PMTFinancial: Returns the periodic payment for an annuity
222POISSON.DISTStatistical: Returns the Poisson distribution
223POWERMath and trigonometry: Returns the result of a number raised to a power
224PPMTFinancial: Returns the payment on the principal for an investment for a given period
225PROBStatistical: Returns the probability that values in a range are between two limits
226PRODUCTMath and trigonometry: Multiplies its arguments
227PROPERText: Capitalizes the first letter in each word of a text value
228PVFinancial: Returns the present value of an investment
229QUARTILE.EXCStatistical: Returns the quartile of the data set, based on percentile values from 0..1, exclusive
230QUARTILE.INCStatistical: Returns the quartile of a data set
231QUOTIENTMath and trigonometry: Returns the integer portion of a division
232RANDMath and trigonometry: Returns a random number between 0 and 1
233RANDBETWEENMath and trigonometry: Returns a random number between the numbers you specify
234RANK.AVGStatistical: Returns the rank of a number in a list of numbers
235RANK.EQStatistical: Returns the rank of a number in a list of numbers
236RATEFinancial: Returns the interest rate per period of an annuity
237REPTText: Repeats text a given number of times
238RIGHTText: Returns the rightmost characters from a text value
239ROMANMath and trigonometry: Converts an arabic numeral to roman, as text
240ROUNDMath and trigonometry: Rounds a number to a specified number of digits
241ROUNDDOWNMath and trigonometry: Rounds a number down, toward zero
242ROUNDUPMath and trigonometry: Rounds a number up, away from zero
243ROWLookup and reference: Returns the row number of a reference
244ROWSLookup and reference: Returns the number of rows in a reference
245RRIFinancial: Returns an equivalent interest rate for the growth of an investment
246RSQStatistical: Returns the square of the Pearson product moment correlation coefficient
247SECMath and trigonometry: Returns the secant of an angle
248SECHMath and trigonometry: Returns the hyperbolic secant of an angle
249SECONDDate and time: Converts a serial number to a second
250SERIESSUMMath and trigonometry: Returns the sum of a power series based on the formula
251SIGNMath and trigonometry: Returns the sign of a number
252SINMath and trigonometry: Returns the sine of the given angle
253SINHMath and trigonometry: Returns the hyperbolic sine of a number
254SKEWStatistical: Returns the skewness of a distribution
255SKEW.PStatistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
256SLNFinancial: Returns the straight-line depreciation of an asset for one period
257SLOPEStatistical: Returns the slope of the linear regression line
258SMALLStatistical: Returns the k-th smallest value in a data set
259SQRTMath and trigonometry: Returns a positive square root
260SQRTPIMath and trigonometry: Returns the square root of (number * pi)
261STANDARDIZEStatistical: Returns a normalized value
262STDEV.PStatistical: Calculates standard deviation based on the entire population
263STDEV.SStatistical: Estimates standard deviation based on a sample
264STDEVAStatistical: Estimates standard deviation based on a sample, including numbers, text, and logical values
265STDEVPCompatibility: Calculates standard deviation based on the entire population
266STDEVPAStatistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values
267STEYXStatistical: Returns the standard error of the predicted y-value for each x in the regression
268SUBSTITUTEText: Substitutes new text for old text in a text string
269SUBTOTALMath and trigonometry: Returns a subtotal in a list or database
270SUMMath and trigonometry: Adds its arguments
271SUMIFMath and trigonometry: Adds the cells specified by a given criteria, only two params SUMIF(RANGE, CRITERIA)
272SUMIFSMath and trigonometry: Adds the cells in a range that meet multiple criteria, only two params SUMIFS(RANGE, CRITERIA)
273SUMPRODUCTMath and trigonometry: Returns the sum of the products of corresponding array components
274SUMSQMath and trigonometry: Returns the sum of the squares of the arguments
275SUMX2MY2Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays
276SUMX2PY2Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays
277SUMXMY2Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays
278SWITCHLogical: Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
279SYDFinancial: Returns the sum-of-years' digits depreciation of an asset for a specified period
280T.DISTStatistical: Returns the Percentage Points (probability) for the Student t-distribution
281T.DIST.2TStatistical: Returns the Percentage Points (probability) for the Student t-distribution
282T.DIST.RTStatistical: Returns the Student's t-distribution
283T.INVStatistical: Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
284T.INV.2TStatistical: Returns the inverse of the Student's t-distribution
285TANMath and trigonometry: Returns the tangent of a number
286TANHMath and trigonometry: Returns the hyperbolic tangent of a number
287TBILLEQFinancial: Returns the bond-equivalent yield for a Treasury bill
288TBILLPRICEFinancial: Returns the price per $100 face value for a Treasury bill
289TBILLYIELDFinancial: Returns the yield for a Treasury bill
290TDISTCompatibility: Returns the Student's t-distribution
291TIMEDate and time: Returns the serial number of a particular time
292TIMEVALUEDate and time: Converts a time in the form of text to a serial number
293TINVCompatibility: Returns the inverse of the Student's t-distribution
294TODAYDate and time: Returns the serial number of today's date
295TRANSPOSELookup and reference: Returns the transpose of an array
296TRENDStatistical: Returns values along a linear trend
297TRIMText: Removes spaces from text
298TRIMMEANStatistical: Returns the mean of the interior of a data set
299TRUELogical: Returns the logical value TRUE
300TRUNCMath and trigonometry: Truncates a number to an integer
301UNICODEText: Returns the number (code point) that corresponds to the first character of the text
302UNIQUELookup and reference: Returns a list of unique values in a list or range
303UPPERText: Converts text to uppercase
304VAR.PStatistical: Calculates variance based on the entire population
305VAR.SStatistical: Estimates variance based on a sample
306VARAStatistical: Estimates variance based on a sample, including numbers, text, and logical values
307VARPCompatibility: Calculates variance based on the entire population
308VARPAStatistical: Calculates variance based on the entire population, including numbers, text, and logical values
309WEEKDAYDate and time: Converts a serial number to a day of the week
310WEEKNUMDate and time: Converts a serial number to a number representing where the week falls numerically with a year
311WEIBULL.DISTStatistical: Returns the Weibull distribution
312WORKDAYDate and time: Returns the serial number of the date before or after a specified number of workdays
313XNPVFinancial: Returns the net present value for a schedule of cash flows that is not necessarily periodic
314XORLogical: Returns a logical exclusive OR of all arguments
315YEARFRACDate and time: Returns the year fraction representing the number of whole days between start_date and end_date