Skip to main content

Supported functions

The following functions and formulas are supported out-of-the-box with Tactyc.

In alphabetical order:

  1. ABS
  2. ACOS
  3. ACOSH
  4. ACOT
  5. ACOTH
  6. ADDRESS
  7. AND
  8. ASIN
  9. ASINH
  10. ATAN
  11. ATAN2
  12. ATANH
  13. CLEAN
  14. CONCAT
  15. CONCATENATE
  16. LEFT
  17. LEN
  18. LOWER
  19. PROPER
  20. REPT
  21. SUBSTITUTE
  22. TRIM
  23. CEILING
  24. MATH
  25. PRECISE
  26. CELL
  27. UPPER
  28. VALUE
  29. AVEDEV
  30. AVERAGE
  31. AVERAGEA
  32. AVERAGEIF
  33. AVERAGEIFS
  34. BESSELI
  35. BESSELJ
  36. CHOOSE
  37. BESSELK
  38. BESSELY
  39. COLUMN
  40. COLUMNS
  41. COMBIN
  42. COMBINA
  43. DIST
  44. INV
  45. BETADIST
  46. BETAINV
  47. BIN2DEC
  48. BIN2HEX
  49. BIN2OCT
  50. DIST
  51. COS
  52. COSH
  53. COT
  54. COTH
  55. INV
  56. BINOMDIST
  57. BITAND
  58. BITLSHIFT
  59. BITOR
  60. BITRSHIFT
  61. BITXOR
  62. CHIDIST
  63. CHIINV
  64. DIST
  65. DIST.RT
  66. INV
  67. INV.RT
  68. TEST
  69. CHITEST
  70. CUMIPMT
  71. CUMPRINC
  72. DATE
  73. DATEDIF
  74. DATEVALUE
  75. CONFIDENCE
  76. DAY
  77. DAYS
  78. DAYS360
  79. DB
  80. NORM
  81. T
  82. CONVERT
  83. DDB
  84. CORREL
  85. COUNT
  86. COUNTA
  87. DEGREES
  88. COUNTBLANK
  89. COUNTIF
  90. COUNTIFS
  91. DISC
  92. COVAR
  93. P
  94. S
  95. DOLLARDE
  96. DOLLARFR
  97. CRITBINOM
  98. CSC
  99. CSCH
  100. EDATE
  101. EFFECT
  102. EOMONTH
  103. EVEN
  104. EXP
  105. DEC2BIN
  106. DEC2HEX
  107. DEC2OCT
  108. DELTA
  109. DEVSQ
  110. FACT
  111. FACTDOUBLE
  112. FALSE
  113. FLOOR
  114. MATH
  115. PRECISE
  116. ERF
  117. PRECISE
  118. ERFC
  119. PRECISE
  120. DIST
  121. EXPONDIST
  122. FV
  123. FVSCHEDULE
  124. DIST
  125. DIST.RT
  126. INV
  127. INV.RT
  128. TEST
  129. FDIST
  130. FINV
  131. GCD
  132. FISHER
  133. FISHERINV
  134. FORECAST
  135. HLOOKUP
  136. HOUR
  137. LINEAR
  138. FREQUENCY
  139. IF
  140. IFERROR
  141. IFNA
  142. IFS
  143. FTEST
  144. GAMMA
  145. DIST
  146. INV
  147. GAMMADIST
  148. GAMMAINV
  149. GAMMALN
  150. PRECISE
  151. GAUSS
  152. GEOMEAN
  153. GESTEP
  154. HARMEAN
  155. HEX2BIN
  156. HEX2DEC
  157. HEX2OCT
  158. DIST
  159. HYPGEOMDIST
  160. INDEX
  161. INDIRECT
  162. INT
  163. INTRATE
  164. IPMT
  165. IRR
  166. ISBLANK
  167. ISERR
  168. ISERROR
  169. ISEVEN
  170. ISFORMULA
  171. ISLOGICAL
  172. ISNA
  173. ISNONTEXT
  174. ISNUMBER
  175. ISODD
  176. ISOWEEKNUM
  177. ISPMT
  178. ISREF
  179. ISTEXT
  180. LN
  181. LOG
  182. LOG10
  183. LOOKUP
  184. MATCH
  185. MDETERM
  186. INTERCEPT
  187. KURT
  188. MINUTE
  189. MIRR
  190. MOD
  191. LARGE
  192. LINEST
  193. MONTH
  194. MROUND
  195. MULTINOMIAL
  196. N
  197. NA
  198. LOGINV
  199. DIST
  200. NETWORKDAYS
  201. INV
  202. NOMINAL
  203. LOGNORMDIST
  204. MAX
  205. MAXA
  206. MAXIFS
  207. MEDIAN
  208. MIN
  209. MINA
  210. MINIFS
  211. NOT
  212. NOW
  213. NPER
  214. NPV
  215. MODE
  216. SNGL
  217. DIST
  218. ODD
  219. OFFSET
  220. OR
  221. PDURATION
  222. NEGBINOMDIST
  223. INTL
  224. DIST
  225. INV
  226. S.DIST
  227. S.INV
  228. NORMDIST
  229. NORMINV
  230. NORMSDIST
  231. NORMSINV
  232. OCT2BIN
  233. PI
  234. PMT
  235. OCT2DEC
  236. OCT2HEX
  237. POWER
  238. PPMT
  239. PEARSON
  240. PRODUCT
  241. PERCENTILE
  242. PV
  243. EXC
  244. INC
  245. QUOTIENT
  246. RADIANS
  247. PERMUT
  248. RATE
  249. PERMUTATIONA
  250. PHI
  251. POISSON
  252. DIST
  253. ROUND
  254. ROUNDDOWN
  255. ROUNDUP
  256. ROW
  257. RRI
  258. QUARTILE
  259. SEC
  260. SECH
  261. SECOND
  262. SERIESSUM
  263. SHEET
  264. SHEETS
  265. SIGN
  266. SIN
  267. SINH
  268. SLN
  269. RANK
  270. AVG
  271. SQRT
  272. SQRTPI
  273. EQ
  274. RSQ
  275. SKEW
  276. P
  277. SLOPE
  278. SMALL
  279. STANDARDIZE
  280. SUBTOTAL
  281. SUM
  282. SUMIF
  283. SUMIFS
  284. SUMPRODUCT
  285. SUMSQ
  286. SUMX2MY2
  287. SUMX2PY2
  288. STDEV
  289. SWITCH
  290. SYD
  291. P
  292. S
  293. STDEVA
  294. STDEVP
  295. STDEVPA
  296. SUMXMY2
  297. TAN
  298. TANH
  299. TBILLEQ
  300. TBILLPRICE
  301. TBILLYIELD
  302. DIST
  303. DIST.2T
  304. DIST.RT
  305. TIME
  306. TIMEVALUE
  307. INV
  308. TODAY
  309. TRANSPOSE
  310. INV.2T
  311. TEST
  312. TDIST
  313. TRUE
  314. TRUNC
  315. TYPE
  316. TINV
  317. TRIMMEAN
  318. TTEST
  319. VAR
  320. P
  321. S
  322. VARA
  323. VARP
  324. VARPA
  325. VLOOKUP
  326. WEEKDAY
  327. WEEKNUM
  328. WEIBULL
  329. DIST
  330. WORKDAY
  331. INTL
  332. XIRR
  333. XNPV
  334. XOR
  335. YEAR
  336. YEARFRAC
  337. Z.TEST
  338. PROPER