Table of Content
Still need help?
Request support
Request Support
Help
 / 
 / 
Deep Dive
 / 

Supported Formulae

Clappia supports form calculations and logic using Excel-like syntax, making it easy for anyone familiar with spreadsheets to create dynamic apps. Most standard Excel formulas work in Clappia, with a few variations and additional functions tailored for app workflows.

Click on this link to learn how to use a formula block in Clappia.

Clappia supports all basic arithmetic operations (addition, subtraction, multiplication, division, remainder) as well as logic-based formulas like IF, AND, and OR.
You can find the complete list of supported formulas in the table at the end of this article.

Examples

Date and Time Formulas

  • Current Date:
    TODAY()
    (Returns today’s date.)

  • Current Date and Time:
    NOW()
    (Returns the current date and time.)

  • Create a Date from Year, Month, Day:
    DATE(2025, 7, 21)
    (Returns 21-July-2025.)

  • Shift Date by Months (e.g., 3 months later):
    EDATE(start_date, 3)
    (Returns the date 3 months after the start date.)

  • Last Day of the Month:
    EOMONTH(start_date, 0)
    (Returns the last day of the current month of start_date.)

  • Days Difference:
    DAYS(end_date, start_date)
    (Number of days between two dates.)

  • Extract Day/Month/Year:

          Extract the day from a date (e.g., 15 from 15/07/2025)
          DAY(date_variable)

          Extract the month from a date (e.g., 7 from 15/07/2025)
          MONTH(date_variable)

          Extract the year from a date (e.g., 2025 from 15/07/2025)
          YEAR(date_variable)

Text and String Formulas

  • Format Numbers or Dates:

         Format a date as YYYY-MM-DD
         TEXT(date_variable, "yyyy-MM-dd")

         Format a number as currency (₹250.50)
         TEXT(amount, "₹0.00")

  • Get Left/Right Characters:

         Return the first 3 characters of a name 
         LEFT(name, 3)

         Return the last 4 digits of a code
         RIGHT(code, 4)

  • Get Text Length:

          Return the number of characters in a description
          LEN(description)

  • Replace Text:

    Change the first 3 characters of "ORD12345" to "INV"
    REPLACE("ORD12345", 1, 3, "INV")

  • Substitute Text:

    Change the first 3 characters of "ORD12345" to "INV"
    SUBSTITUTE("123-456-123", "123", "000")

  • String Concatenation: Combine first_name, middle_name, and last_name into one string:
    first_name & " " & middle_name & " " & last_name
    (Note: Text strings must be enclosed in double quotes.)


Rounding Off Formulae

  • Round off a number (some_number) to 2 decimal places:
    ROUND(some_number, 2)

  • Round off a number (some_number) to the nearest 10:
    ROUND(some_number, -1)

  • Round off a number (some_number) to the nearest 100:
    ROUND(some_number, -2)

  • Round up a number (some_number) to the nearest 10:
    ROUNDUP(some_number, -1)

  • Round up a number (some_number) to the nearest 100:
    ROUNDUP(some_number, -2)

Interest Calculation Formulae

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

If/Else Formulae

  • Example: Show "Pass" if the score is greater than 50, otherwise show "Fail":
    IF(score > 50, "Pass", "Fail")

Nested Conditions

You can combine multiple conditions in a single formula using nested IF statements or logical operators like AND and OR.

Examples:

  • Nested IF:
    If the score is greater than 80 show “Excellent”, else if greater than 50 show “Pass”, otherwise “Fail”.
    IF(score > 80, "Excellent", IF(score > 50, "Pass", "Fail"))

  • IF with AND:
    Checks if both conditions are true.
    IF(AND(age > 18, city = "Delhi"), "Eligible", "Not Eligible")

  • IF with OR:
    Checks if any one condition is true.
    IF(OR(role = "Manager", role = "Supervisor"), "Approved", "Pending")

Supported Formula Table

Note
The column “Appears in Formula Suggestions?” indicates whether the formula appears in the auto-suggestion dropdown when typing in the formula field. Some formulas may not appear in the dropdown but are still fully supported if entered correctly.

FormulaAppears in Formula Suggestions?
ABSYes
ACOSYes
ACOSHYes
ACOTYes
ACOTHYes
ADDYes
ANDYes
ARABICNo
ARRAYFORMULANo
ARRAY_CONSTRAINNo
ASINYes
ASINHYes
ATANYes
ATAN2No
ATANHYes
AVEDEVNo
AVERAGENo
AVERAGEANo
AVERAGEIFNo
BASENo
BASE64DECODEYes
BASE64ENCODEYes
BESSELINo
BESSELJNo
BESSELKNo
BESSELYNo
BETADISTNo
BETAINVNo
BIN2DECNo
BIN2HEXNo
BIN2OCTNo
BINOMDISTNo
BITANDYes
BITLSHIFTNo
BITORYes
BITRSHIFTNo
BITXORYes
CEILINGYes
CHARNo
CHIDISTNo
CHIDISTRTNo
CHIINVNo
CHIINVRTNo
CHITESTNo
CHOOSENo
CLEANNo
CODENo
COLUMNNo
COLUMNSNo
COMBINNo
COMBINANo
COMPLEXNo
CONCATENATEYes
CONFIDENCENo
CONTAINSYes
CORRELNo
COSYes
COSHNo
COTYes
COTHYes
COUNTYes
COUNTANo
COUNTBLANKNo
COUNTIFNo
COUNTIFSNo
COUNTUNIQUENo
COVARNo
COVARIANCEPNo
COVARIANCESNo
CRITBINOMNo
CSCYes
CSCHNo
CUMIPMTNo
CUMPRINCNo
DATEYes
DATEDIFYes
DATEVALUENo
DAYYes
DAYSNo
DAYS360No
DBNo
DDBNo
DEC2BINNo
DEC2HEXNo
DEC2OCTNo
DECIMALNo
DECODEURLYes
DEGREESYes
DELTANo
DEVSQNo
DIVIDEYes
DOLLARDENo
DOLLARFRNo
EDATEYes
EFFECTNo
ENCODEURLYes
EOMONTHYes
ERFNo
ERFCNo
EVENYes
EXACTNo
EXPNo
EXPONDISTNo
FACTYes
FACTDOUBLENo
FALSEYes
FDISTNo
FDISTRTNo
FILTERNo
FINDNo
FINVNo
FINVRTNo
FISHERNo
FISHERINVNo
FLOORYes
FORMULATEXTNo
FTESTNo
FVNo
FVSCHEDULENo
GAMMANo
GAMMADISTNo
GAMMAINVNo
GAMMALNNo
GAUSSNo
GCDNo
GEOMEANNo
GETYes
HARMEANNo
HEX2BINNo
HEX2DECNo
HEX2OCTNo
HLOOKUPNo
HOURNo
HYPGEOMDISTNo
IFYes
IFERRORNo
IFNANo
IMABSNo
IMAGINARYNo
IMARGUMENTNo
IMCONJUGATENo
IMCOSNo
IMCOSHNo
IMCOTNo
IMCSCNo
IMCSCHNo
IMDIVNo
IMEXPNo
IMLNNo
IMLOG10No
IMLOG2No
IMPOWERNo
IMPRODUCTNo
IMREALNo
IMSECNo
IMSECHNo
IMSINNo
IMSINHNo
IMSQRTNo
IMSUBNo
IMSUMNo
IMTANNo
INDEXYes
INTYes
INTERVALNo
IPMTNo
ISBINARYNo
ISBLANKNo
ISERRNo
ISERRORNo
ISEVENNo
ISFORMULANo
ISLOGICALNo
ISNANo
ISNONTEXTNo
ISNUMBERNo
ISODDNo
ISOWEEKNUMNo
ISPMTNo
ISREFNo
ISTEXTNo
JOINYes
LARGENo
LCMNo
LEFTYes
LENYes
LNNo
LOGYes
LOG10Yes
LOGINVNo
LOGNORMDISTNo
LOGNORMINVNo
LOWERYes
MATCHNo
MAXYes
MAXANo
MAXPOOLNo
MEDIANNo
MEDIANPOOLNo
MIDNo
MINYes
MINANo
MINUSYes
MINUTENo
MIRRNo
MMULTNo
MODNo
MONTHYes
MROUNDYes
MULTINOMIALNo
MULTIPLYYes
NANo
NEGBINOMDISTNo
NETWORKDAYSNo
NOMINALNo
NORMDISTNo
NORMDISTNo
NORMINVNo
NORMSINVNo
NOTYes
NOWYes
NPERNo
NPVNo
OCT2BINNo
OCT2DECNo
OCT2HEXNo
ODDNo
OFFSETNo
ORYes
PDURATIONNo
PEARSONNo
PHINo
PIYes
PMTNo
POISSONNo
POISSONDISTNo
POWYes
POWERYes
PPMTNo
PRODUCTYes
PROPERNo
PVNo
QUOTIENTNo
RADIANSNo
RANDYes
RANDBETWEENYes
RATENo
REGEXEXTRACTYes
REGEXMATCHYes
REGEXREPLACEYes
REPLACENo
REPTYes
RIGHTYes
ROMANNo
ROUNDYes
ROUNDDOWNYes
ROUNDUPYes
ROWNo
ROWSNo
RRINo
RSQNo
SEARCHYes
SECNo
SECHNo
SECONDNo
SERIESSUMNo
SHEETNo
SHEETSNo
SIGMAYes
SIGNNo
SINYes
SINHNo
SKEWNo
SKEWPNo
SLNNo
SLOPENo
SMALLNo
SPELLNUMBERYes
SPLITNo
SPLITSTRYes
SQRTYes
SQRTPIYes
STANDARDIZENo
STDEVNo
STDEVANo
STDEVPNo
STDEVPANo
STDEVSNo
STEYXNo
SUBSTITUTENo
SUBTOTALNo
SUMYes
SUMIFNo
SUMIFSNo
SUMPRODUCTNo
SUMSQYes
SUMX2MY2No
SUMX2PY2No
SUMXMY2No
SWITCHNo
SYDNo
TNo
TANYes
TANHYes
TBILLEQNo
TBILLPRICENo
TBILLYIELDNo
TDISTNo
TDIST2TNo
TDISTRTNo
TEXTYes
TIMENo
TIMEVALUENo
TINVNo
TINV2TNo
TODAYYes
TRANSPOSENo
TRIMNo
TRUEYes
TRUNCYes
TTESTNo
UNICHARNo
UNICODENo
UPPERYes
VARNo
VARANo
VARPNo
VARPANo
VARSNo
VLOOKUPNo
WEEKDAYYes
WEEKNUMYes
WEIBULLNo
WEIBULLDISTNo
WORKDAYNo
XNPVNo
XORYes
YEARYes
YEARFRACNo
ZTESTNo
FAQs
Try our free plan
It will answer many more questions within just 15 minutes.