MESCIUS SPREAD for Windows Forms 15.0J 関数リファレンス
関数一覧

ここでは、SPREAD for Windows Formsの備える組み込み関数をアルファベット順に一覧表示します。

種類別の関数一覧については、「関数の種類」を参照してください。

関数 A から C

ABS ACCRINT ACCRINTM ACOS
ACOSH ACOT ACOTH ADDRESS
AGGREGATE AMORDEGRC AMORLINC ANCHORARRAY
ARABIC AREAS ASC ASIN
ASINH ATAN ATAN2 ATANH
AVEDEV AVERAGE AVERAGEA AVERAGEIF
AVERAGEIFS BAHTTEXT BASE BESSELI
BESSELJ BESSELK BESSELY BETA.DIST
BETA.INV BETADIST BETAINV BIN2DEC
BIN2HEX BIN2OCT BINOM.DIST BINOM.DIST.RANGE
BINOM.INV BINOMDIST BITAND BITLSHIFT
BITOR BITRSHIFT BITXOR
CEILING CEILING.MATH CEILING.PRECISE CELL
CHAR CHIDIST CHIINV CHISQ.DIST
CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST
CHITEST CHOOSE CLEAN CODE
COLUMN COLUMNS COMBIN COMBINA
COMPLEX CONCAT CONCATENATE CONFIDENCE
CONFIDENCE.NORM CONFIDENCE.T CONVERT CORREL
COS COSH COT COTH
COUNT COUNTA COUNTBLANK COUNTIF
COUNTIFS COUPDAYBS COUPDAYS COUPDAYSNC
COUPNCD COUPNUM COUPPCD COVAR
COVARIANCE.P COVARIANCE.S CRITBINOM CSC
CSCH
CUMIPMT CUMPRINC

関数 D から G

DATE DATEDIF DATEVALUE DAVERAGE
DAY DAYS360 DB DCOUNT
DCOUNTA DDB DEC2BIN DEC2HEX
DEC2OCT DEGREES DELTA DEVSQ
DGET DISC DMAX DMIN
DOLLAR DOLLARDE DOLLARFR DPRODUCT
DSTDEV DSTDEVP DSUM DURATION
DVAR DVARP EDATE EFFECT
EOMONTH ERF ERFC ERRORTYPE
EUROCONVERT EVEN EXACT EXP
EXPONDIST FACT FACTDOUBLE FALSE
FDIST FILTER FIND FINV
FISHERINV FIXED FLOOR FORECAST
FREQUENCY FTEST FV FVSCHEDULE
GAMMADIST GAMMAINV GAMMALN GCD
GEOMEAN GESTEP GROWTH

関数 H から L

HARMEAN HEX2BIN HEX2DEC HEX2OCT
HLOOKUP HOUR HYPERLINK HYPGEOM.DIST
HYPGEOMDIST IF IFERROR IFNA
IFS IMABS IMAGINARY IMARGUMENT
IMCONJUGATE IMCOS IMCOSH IMCOT
IMCSC IMCSCH IMDIV IMEXP
IMLN IMLOG10 IMLOG2 IMPOWER
IMPRODUCT IMREAL IMSEC IMSECH
IMSIN IMSINH IMSQRT IMSUB
IMSUM IMTAN INDEX INDIRECT
INFO INT INTERCEPT INTRATE
IPMT IRR ISBLANK ISERR
ISERROR ISEVEN ISFORMULA ISLOGICAL
ISNA ISNONTEXT ISNUMBER ISO.CEILING
ISODD ISOWEEKNUM ISPMT ISREF
ISTEXT JIS KURT LARGE
LCM LEFT LEFTB LEN
LENB LINEST LN LOG
LOG10 LOGEST LOGINV LOGNORM.DIST
LOGNORM.INV LOGNORMDIST LOOKUP LOWER

関数 M から Q

MATCH MAX MAXA MAXIFS
MDETERM MDURATION MEDIAN MID
MIDB MIN MINA MINIFS
MINUTE MINVERSE MIRR MMULT
MOD MODE MODE.MULT MODE.SNGL
MONTH MROUND MULTINOMIAL MUNIT
N NA NEGBINOM.DIST NEGBINOMDIST
NETWORKDAYS NETWORKDAYS.INTL NOMINAL NORM.DIST
NORM.INV NORM.S.DIST NORM.S.INV NORMDIST
NORMINV NORMSDIST NORMSINV NOT
NOW NPER NPV NUMBERVALUE
OCT2BIN OCT2DEC OCT2HEX ODD
ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD
OFFSET OR PDURATION PEARSON
PERCENTILE PERCENTILE.EXC PERCENTILE.INC PERCENTRANK
PERCENTRANK.EXC PERCENTRANK.INC PERMUT PERMUTATIONA
PHI PI PMT POISSON
POISSON.DIST POWER PPMT PRICE
PRICEDISC PRICEMAT PROB PRODUCT
PROPER PV QUARTILE QUARTILE.EXC
QUARTILE.INC QUOTIENT

関数 R から S

RADIANS RAND RANDARRAY RANDBETWEEN
RANK RANK.AVG RANK.EQ RATE
RECEIVED REPLACE REPLACEB REPT
RIGHT RIGHTB ROMAN ROUND
ROUNDDOWN ROUNDUP ROW ROWS
RRI RSQ RTD SEARCH
SEARCHB SEC SECH SECOND
SEQUENCE SERIESSUM SHEET SHEETS
SIGN SIN SINGLE SINH
SKEW SKEW. P SLN SLOPE
SMALL SORT SORTBY SQRT
SQRTPI STANDARDIZE STDEV STDEV.P
STDEV.S STDEVA STDEVP STDEVPA
STEYX SUBSTITUTE SUBTOTAL SUM
SUMIF SUMIFS SUMPRODUCT SUMSQ
SUMX2MY2 SUMX2PY2 SUMXMY2 SWITCH
SYD

関数 T から Z

T T.DIST T.DIST.2T T.DIST.RT
T.INV T.INV.2T T.TEST TAN
TANH TBILLEQ TBILLPRICE TBILLYIELD
TDIST TEXT TEXTJOIN TIME
TIMEVALUE TINV TODAY TRANSPOSE
TREND TRIM TRIMMEAN TRUE
TRUNC TTEST TYPE UNICHAR
UNICODE UNIQUE UPPER USDOLLAR
VALUE VAR VAR.P VAR.S
VARA VARP VARPA VDB
VLOOKUP WEBSERVICE WEEKDAY WEEKNUM
WEIBULL WEIBULL.DIST WORKDAY WORKDAY.INTL
XIRR XLOOKUP XMATCH XNPV
XOR YEAR YEARFRAC YIELD
YIELDDISC YIELDMAT Z.TEST ZTEST

各関数の詳しい使用方法については、「数式の概要」、およびSPREAD for Windows Forms 製品ヘルプの「開発者ガイド」の「数式」の章を参照してください。

関数リファレンスの概要については、「関数リファレンス」を参照してください。

 

 


© MESCIUS inc. All rights reserved.