New Formulae

Clappia supports form calculations and logic through the syntax of Excel. Click on this link to learn how to use a formula block in Clappia.

Apart from basic arithmetic symbols (plus,minus,multiply,divide,remainder) and IF/AND/OR formulas, Clappia also supports the following formulas:

  1. ABS
  2. ACCRINT
  3. ACOS
  4. ACOSH
  5. ACOT
  6. ACOTH
  7. ADD
  8. AGGREGATE
  9. AND
  10. ARABIC
  11. ARGS2ARRAY
  12. ASIN
  13. ASINH
  14. ATAN
  15. ATAN2
  16. ATANH
  17. AVEDEV
  18. AVERAGE
  19. AVERAGEA
  20. AVERAGEIF
  21. AVERAGEIFS
  22. BASE
  23. BESSELI
  24. BESSELJ
  25. BESSELK
  26. BESSELY
  27. BETA.DIST
  28. BETA.INV
  29. BETADIST
  30. BETAINV
  31. BIN2DEC
  32. BIN2HEX
  33. BIN2OCT
  34. BINOM.DIST
  35. BINOM.DIST.RANGE
  36. BINOM.INV
  37. BINOMDIST
  38. BITAND
  39. BITLSHIFT
  40. BITOR
  41. BITRSHIFT
  42. BITXOR
  43. CEILING
  44. CEILINGMATH
  45. CEILINGPRECISE
  46. CHAR
  47. CHISQ.DIST
  48. CHISQ.DIST.RT
  49. CHISQ.INV
  50. CHISQ.INV.RT
  51. CHOOSE
  52. CHOOSE
  53. CLEAN
  54. CODE
  55. COLUMN
  56. COLUMNS
  57. COMBIN
  58. COMBINA
  59. COMPLEX
  60. CONCATENATE
  61. CONFIDENCE
  62. CONFIDENCE.NORM
  63. CONFIDENCE.T
  64. CONVERT
  65. CORREL
  66. COS
  67. COSH
  68. COT
  69. COTH
  70. COUNT
  71. COUNTA
  72. COUNTBLANK
  73. COUNTIF
  74. COUNTIFS
  75. COUNTIN
  76. COUNTUNIQUE
  77. COVARIANCE.P
  78. COVARIANCE.S
  79. CSC
  80. CSCH
  81. CUMIPMT
  82. CUMPRINC
  83. DATE
  84. DATEVALUE
  85. DAY
  86. DAYS
  87. DAYS360
  88. DB
  89. DDB
  90. DEC2BIN
  91. DEC2HEX
  92. DEC2OCT
  93. DECIMAL
  94. DEGREES
  95. DELTA
  96. DEVSQ
  97. DIVIDE
  98. DOLLARDE
  99. DOLLARFR
  100. E
  101. EDATE
  102. EFFECT
  103. EOMONTH
  104. EQ
  105. ERF
  106. ERFC
  107. EVEN
  108. EXACT
  109. EXP
  110. EXPON.DIST
  111. EXPONDIST
  112. F.DIST
  113. F.DIST.RT
  114. F.INV
  115. F.INV.RT
  116. FACT
  117. FACTDOUBLE
  118. FALSE
  119. FDIST
  120. FDISTRT
  121. FIND
  122. FINV
  123. FINVRT
  124. FISHER
  125. FISHERINV
  126. FLATTEN
  127. FLOOR
  128. FORECAST
  129. FREQUENCY
  130. FV
  131. FVSCHEDULE
  132. GAMMA
  133. GAMMA.DIST
  134. GAMMA.INV
  135. GAMMADIST
  136. GAMMAINV
  137. GAMMALN
  138. GAMMALN.PRECISE
  139. GAUSS
  140. GCD
  141. GEOMEAN
  142. GESTEP
  143. GROWTH
  144. GTE
  145. HARMEAN
  146. HEX2BIN
  147. HEX2DEC
  148. HEX2OCT
  149. HOUR
  150. HTML2TEXT
  151. HYPGEOM.DIST
  152. HYPGEOMDIST
  153. IF
  154. IMABS
  155. IMAGINARY
  156. IMARGUMENT
  157. IMCONJUGATE
  158. IMCOS
  159. IMCOSH
  160. IMCOT
  161. IMCSC
  162. IMCSCH
  163. IMDIV
  164. IMEXP
  165. IMLN
  166. IMLOG10
  167. IMLOG2
  168. IMPOWER
  169. IMPRODUCT
  170. IMREAL
  171. IMSEC
  172. IMSECH
  173. IMSIN
  174. IMSINH
  175. IMSQRT
  176. IMSUB
  177. IMSUM
  178. IMTAN
  179. INT
  180. INTERCEPT
  181. INTERVAL
  182. IPMT
  183. IRR
  184. ISBINARY
  185. ISBLANK
  186. ISEVEN
  187. ISLOGICAL
  188. ISNONTEXT
  189. ISNUMBER
  190. ISODD
  191. ISODD
  192. ISOWEEKNUM
  193. ISPMT
  194. ISTEXT
  195. JOIN
  196. KURT
  197. LARGE
  198. LCM
  199. LEFT
  200. LEN
  201. LINEST
  202. LN
  203. LOG
  204. LOG10
  205. LOGEST
  206. LOGNORM.DIST
  207. LOGNORM.INV
  208. LOGNORMDIST
  209. LOGNORMINV
  210. LOWER
  211. LT
  212. LTE
  213. MATCH
  214. MAX
  215. MAXA
  216. MEDIAN
  217. MID
  218. MIN
  219. MINA
  220. MINUS
  221. MINUTE
  222. MIRR
  223. MOD
  224. MODE.MULT
  225. MODE.SNGL
  226. MODEMULT
  227. MODESNGL
  228. MONTH
  229. MROUND
  230. MULTINOMIAL
  231. MULTIPLY
  232. NE
  233. NEGBINOM.DIST
  234. NEGBINOMDIST
  235. NETWORKDAYS
  236. NOMINAL
  237. NORM.DIST
  238. NORM.INV
  239. NORM.S.DIST
  240. NORM.S.INV
  241. NORMDIST
  242. NORMINV
  243. NORMSDIST
  244. NORMSINV
  245. NOT
  246. NOW
  247. NPER
  248. NPV
  249. NUMBERS
  250. OCT2BIN
  251. OCT2DEC
  252. OCT2HEX
  253. ODD
  254. OR
  255. PDURATION
  256. PEARSON
  257. PERCENTILEEXC
  258. PERCENTILEINC
  259. PERCENTRANKEXC
  260. PERCENTRANKINC
  261. PERMUT
  262. PERMUTATIONA
  263. PHI
  264. PI
  265. PMT
  266. POISSON.DIST
  267. POISSONDIST
  268. POW
  269. POWER
  270. PPMT
  271. PROB
  272. PRODUCT
  273. PROPER
  274. PV
  275. QUARTILE.EXC
  276. QUARTILE.INC
  277. QUARTILEEXC
  278. QUARTILEINC
  279. QUOTIENT
  280. RADIANS
  281. RAND
  282. RANDBETWEEN
  283. RANK.AVG
  284. RANK.EQ
  285. RANKAVG
  286. RANKEQ
  287. RATE
  288. REFERENCE
  289. REGEXEXTRACT
  290. REGEXMATCH
  291. REGEXREPLACE
  292. REPLACE
  293. REPT
  294. RIGHT
  295. ROMAN
  296. ROUND
  297. ROUNDDOWN
  298. ROUNDUP
  299. ROW
  300. ROWS
  301. RRI
  302. RSQ
  303. SEARCH
  304. SEC
  305. SECH
  306. SECOND
  307. SERIESSUM
  308. SIGN
  309. SIN
  310. SINH
  311. SKEW
  312. SKEW.P
  313. SKEWP
  314. SLN
  315. SLOPE
  316. SMALL
  317. SPLIT
  318. SPLIT
  319. SQRT
  320. SQRTPI
  321. STANDARDIZE
  322. STDEV.P
  323. STDEV.S
  324. STDEVA
  325. STDEVP
  326. STDEVPA
  327. STDEVS
  328. STEYX
  329. SUBSTITUTE
  330. SUBTOTAL
  331. SUM
  332. SUMIF
  333. SUMIFS
  334. SUMPRODUCT
  335. SUMSQ
  336. SUMX2MY2
  337. SUMX2PY2
  338. SUMXMY2
  339. SWITCH
  340. SYD
  341. T
  342. T.DIST
  343. T.DIST.2T
  344. T.DIST.RT
  345. T.INV
  346. T.INV.2T
  347. TAN
  348. TANH
  349. TBILLEQ
  350. TBILLPRICE
  351. TBILLYIELD
  352. TDIST
  353. TDIST2T
  354. TDISTRT
  355. TIME
  356. TIMEVALUE
  357. TINV
  358. TINV2T
  359. TODAY
  360. TRANSPOSE
  361. TREND
  362. TRIM
  363. TRIMMEAN
  364. TRUE
  365. TRUNC
  366. UNICHAR
  367. UNICODE
  368. UNIQUE
  369. UPPER
  370. VAR.P
  371. VAR.S
  372. VARA
  373. VARP
  374. VARPA
  375. VARS
  376. WEEKDAY
  377. WEEKNUM
  378. WEIBULL.DIST
  379. WEIBULLDIST
  380. WORKDAY
  381. XIRR
  382. XNPV
  383. XOR
  384. YEAR
  385. YEARFRAC

Here is the link of the app in which some of the above formulas are used
Link :

Related Articles