Supported 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.

Clappia supports all basic arithmetic symbols (plus, minus, multiply, divide, remainder) and IF/AND/OR formulas. Apart from that, find the list of all supported formulae at the bottom.

Examples

Rounding Off Formulae

• Round off a number (variable name = some_number) to 2 decimal places:  ROUND(some_number, 2)
• Round off a number (variable name = some_number) to the nearest 10: ROUND(some_number, -1)
• Round off a number (variable name = some_number) to the nearest 100: ROUND(some_number, -2)
• Round UP a number (variable name = some_number) to the nearest 10: ROUNDUP(some_number, -1)
• Round UP a number (variable name = some_number) to the nearest 10: ROUNDUP(some_number, -2)

Interest Calculation Formulae

Calculating Compound Interest:
base_amount * POW((1 + interest_rate/(100*12)), years*12)

If/Else Formulae

String Formulae

• String concatenation: (variable names - first_name, middle_name, last_name): first_name & " " & middle_name & " " & last_name

All supported formulae

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