このトピックで
Forguncyでは、以下のExcel関数、およびForguncy固有の関数を使うことができます。
Forguncyの関数であるODATAについてはODataを、GETPARAMについてはGETPARAM関数を、GetURLQueryValueについてはGETURLQUERYVALUE関数を参照してください。
統計
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETADIST
BETAINV
BINOMDIST
BINOMDISTRANGE
BINOMINV
BINOMDIST
CHIDIST
CHIINV
CHISQDIST
CHISQDISTRT
CHISQINV
CHISQINVRT
CHISQTEST
CHITEST
CONFIDENCE
CONFIDENCENORM
CONFIDENCET
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVER
COVARIANCEP
COVARIANCES
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FDISTRT
FINV
FINVRT
FISHER
FISHERINV
FORECAST
FREQUENCY
FTEST
GAMMA
GAMMADIST
GAMMAINV
GAMMALN
GAMMALNV
GAMMALNPRECISE
GAUSS
GEOMEAN
GROWTH
HARMEAN
HYPGECOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGINV
LOGNORMDIST
LOGNORMINV
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
MODE
MINIFS
MODESNGL
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTILEEXC
PERCENTILEINC
PERCENTRANK
PERCENTRANKEXC
PERCENTRANKINC
PERMUT
PERMUTATTONA
PHI
POISSON
POISSONDIST
PROB
QUARTILE
QUARTILEEXC
QUARTILEINC
RANK
PANKAVG
RANKEQ
RSQ
SKEW
SKEWP
SLOPE
SMALL
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVS
STDEVPA
STEYX
TDIST
TDIST2T
TDISTRT
TINV
TINA2T
TREND
TRIMMEAN
TTEST
VAR
VARA
VARP
VARS
VARPA
WEIBULL
WEIBULLDIST
ZTEST
論理
AND
FALSE
IF
IFNA
IFS
IFERROR
NOT
OR
SWITCH
TRUE
XOR
情報
ERROR.TYPE
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
N
NA
TYPE
検索／行列
ADDRESS
AREAS
CHOOSE
COLUMN
COLUMNS
FORMULATEXT
HLOOKUP
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
TRANSPOSE
VLOOKUP
財務
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
EURO
EUROCONVERT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
データベース
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
日付／時刻
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYSINTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAYINTL
YEAR
YEARFRAC
エンジニアリング
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BITOR
BITRSHIFT
BITXOR
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFPRECISE
ERFC
ERFCPRECISE
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
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
OCT2BIN
OCT2DEC
OCT2HEX
文字列操作
ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DOLLAR
EXACT
FIND
FINDB
FIXED
GETURLQUERYVALUE
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTJOIN
TEXTJOINIF
TRIM
UNICHAR
UNICODE
UPPER
VALUE
数学／三角
ABS
ACOS
ACOSH
ACOT
ACOTH
ARABIC
ASIN
ASINH
ATAN
ATAN2
ATANH
BASE
CEILING
CEILINGMATH
CEILINGPRECISE
COMBIN
COMBINA
COS
COSH
COT
COTH
CSC
CSCH
DECIMAL
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
FLOORMATH
FLOORPRECISE
GCD
INT
ISOCEILING
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
MUNIT
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
Forguncy関数
ODATA
TEXTJOINIF
GETPARAM
GETURLQUERYVALUE