Supported functions
The following functions and formulas are supported out-of-the-box with Tactyc.
In alphabetical order:
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AND
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CLEAN
- CONCAT
- CONCATENATE
- LEFT
- LEN
- LOWER
- PROPER
- REPT
- SUBSTITUTE
- TRIM
- CEILING
- MATH
- PRECISE
- CELL
- UPPER
- VALUE
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BESSELI
- BESSELJ
- CHOOSE
- BESSELK
- BESSELY
- COLUMN
- COLUMNS
- COMBIN
- COMBINA
- DIST
- INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- DIST
- COS
- COSH
- COT
- COTH
- INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- CHIDIST
- CHIINV
- DIST
- DIST.RT
- INV
- INV.RT
- TEST
- CHITEST
- CUMIPMT
- CUMPRINC
- DATE
- DATEDIF
- DATEVALUE
- CONFIDENCE
- DAY
- DAYS
- DAYS360
- DB
- NORM
- T
- CONVERT
- DDB
- CORREL
- COUNT
- COUNTA
- DEGREES
- COUNTBLANK
- COUNTIF
- COUNTIFS
- DISC
- COVAR
- P
- S
- DOLLARDE
- DOLLARFR
- CRITBINOM
- CSC
- CSCH
- EDATE
- EFFECT
- EOMONTH
- EVEN
- EXP
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- DEVSQ
- FACT
- FACTDOUBLE
- FALSE
- FLOOR
- MATH
- PRECISE
- ERF
- PRECISE
- ERFC
- PRECISE
- DIST
- EXPONDIST
- FV
- FVSCHEDULE
- DIST
- DIST.RT
- INV
- INV.RT
- TEST
- FDIST
- FINV
- GCD
- FISHER
- FISHERINV
- FORECAST
- HLOOKUP
- HOUR
- LINEAR
- FREQUENCY
- IF
- IFERROR
- IFNA
- IFS
- FTEST
- GAMMA
- DIST
- INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- PRECISE
- GAUSS
- GEOMEAN
- GESTEP
- HARMEAN
- HEX2BIN
- HEX2DEC
- HEX2OCT
- DIST
- HYPGEOMDIST
- INDEX
- INDIRECT
- INT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
- LN
- LOG
- LOG10
- LOOKUP
- MATCH
- MDETERM
- INTERCEPT
- KURT
- MINUTE
- MIRR
- MOD
- LARGE
- LINEST
- MONTH
- MROUND
- MULTINOMIAL
- N
- NA
- LOGINV
- DIST
- NETWORKDAYS
- INV
- NOMINAL
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- NOT
- NOW
- NPER
- NPV
- MODE
- SNGL
- DIST
- ODD
- OFFSET
- OR
- PDURATION
- NEGBINOMDIST
- INTL
- DIST
- INV
- S.DIST
- S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- OCT2BIN
- PI
- PMT
- OCT2DEC
- OCT2HEX
- POWER
- PPMT
- PEARSON
- PRODUCT
- PERCENTILE
- PV
- EXC
- INC
- QUOTIENT
- RADIANS
- PERMUT
- RATE
- PERMUTATIONA
- PHI
- POISSON
- DIST
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- RRI
- QUARTILE
- SEC
- SECH
- SECOND
- SERIESSUM
- SHEET
- SHEETS
- SIGN
- SIN
- SINH
- SLN
- RANK
- AVG
- SQRT
- SQRTPI
- EQ
- RSQ
- SKEW
- P
- SLOPE
- SMALL
- STANDARDIZE
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- STDEV
- SWITCH
- SYD
- P
- S
- STDEVA
- STDEVP
- STDEVPA
- SUMXMY2
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- DIST
- DIST.2T
- DIST.RT
- TIME
- TIMEVALUE
- INV
- TODAY
- TRANSPOSE
- INV.2T
- TEST
- TDIST
- TRUE
- TRUNC
- TYPE
- TINV
- TRIMMEAN
- TTEST
- VAR
- P
- S
- VARA
- VARP
- VARPA
- VLOOKUP
- WEEKDAY
- WEEKNUM
- WEIBULL
- DIST
- WORKDAY
- INTL
- XIRR
- XNPV
- XOR
- YEAR
- YEARFRAC
- Z.TEST
- PROPER