Zapof Forms: Free Online Form Builder & Form Creator
Blog
Product
How-to
Pricing
Form Templates
FREE
Sign up
Sign in
Zapof Functions Listed by Category
Math operation
Binary operators
+
: plus
-
: minus
/
: divide
*
: multiply
&
: bitwise AND
^
: exponentiation
Comparison operators
=
: equal
<
: less than
>
: greater than equal
>
: greater than equal
>=
: greater than equal
<>
: not equal
Unary operators
+
: plus
-
: negation
%
: percent
Logical functions
The Logical functions allow boolean logic decisions.
AND
,
FALSE
,
IF
, IFERROR, IFNA,
NOT
,
OR
, SWITCH,
TRUE
, XOR
Date & Time functions
The Date & Time functions are used to manipulate dates and times.
TODAY
,
NOW
,
YEAR
,
MONTH
,
DAY
,
WEEKDAY
,
HOUR
,
MINUTE
,
SECOND
,
DATE
,
DATEVALUE
,
TIME
,
TIMEVALUE
,
EOMONTH
,
EDATE
, INTERVAL,
WORKDAY
, WORKDAY.INTL,
NETWORKDAYS
, NETWORKDAYS.INTL,
DAYS
,
DAYS360
,
DAYSINMONTH
,
DAYSINYEAR
,
WEEKS
,
WEEKSINYEAR
, WORKDAY.INTL,
WEEKNUM
, ISOWEEKNUM,
MONTHS
,
YEARS
,
ISLEAPYEAR
,
YEARFRAC
Text functions
The Text functions manipulate or return text.
BASE
,
CHAR
, CHARAT,
CLEAN
,
CODE
,
CONCATENATE
, DBCS,
DOLLAR
,
EXACT
,
FIND
,
FIXED
,
LEFT
,
LEN
,
LOWER
,
MID
, NUMBERVALUE,
PROPER
, REGEXEXTRACT, REGEXMATCH, REGEXREPLACE,
REPLACE
,
REPT
,
RIGHT
,
SEARCH
, SPLIT,
SUBSTITUTE
,
T
,
TEXT
,
TRIM
, UNICHAR, UNICODE,
UPPER
,
VALUE
STARTSWITH, ENDSWITH, INDEXOF, LASTINDEXOF, PADSTART, PADEND, REPEAT, TRIMSTART, TRIMEND
Mathematical functions
The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.
COS
,
SIN
,
TAN
,
COT
,
ACOS
,
ACOT
,
ASIN
,
ATAN
,
ATAN2
,
DEGREES
,
RADIANS
,
PI
E.CONST, LN2.CONST, LN10.CONST, LOG2E.CONST, LOG10E.CONST, SQRT1_2.CONST
COSH
,
SINH
,
TANH
,
COTH
,
ACOSH
,
ACOTH
,
ASINH
,
ATANH
,
CSC
,
CSCH
,
SEC
, SECH
TRUNC
,
ROUND
,
ROUNDDOWN
,
ROUNDUP
, FROUND,
CEILING
, CEILING.MATH, CEILING.PRECISE,
FLOOR
, FLOOR.MATH, FLOOR.PRECISE,
EVEN
,
ODD
,
MROUND
,
INT
,
QUOTIENT
,
MOD
EXP
,
POWER
, POW,
LOG
,
LN
,
LOG10
, LOG1P, LOG2, CBRT, CLZ32, EXPM1
ABS
,
COMBIN
,
COMBINA
,
CONVERT
,
COUNTBLANK
,
COUNTIF
, COUNTIFS,
DELTA
,
ERF
,
ERFC
,
FACT
,
FACTDOUBLE
,
GCD
,
GESTEP
,
ISEVEN
,
ISODD
,
LCM
,
MULTINOMIAL
,
PRODUCT
,
RAND
,
RANDBETWEEN
,
SERIESSUM
,
SIGN
,
SQRT
,
SQRTPI
,
SUBTOTAL
,
SUM
,
SUMIF
, SUMIFS, SUMPRODUCT,
SUMSQ
, SUMX2MY2, SUMX2PY2, SUMXMY2
BESSELI
,
BESSELJ
,
BESSELK
,
BESSELY
,
ADD, MINUS, DIVIDE, MULTIPLY, GT, GTE, LT, LTE, EQ, NE
Complex Number functions
The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
COMPLEX
,
IMABS
,
IMAGINARY
,
IMPOWER
,
IMARGUMENT
,
IMCOS
,
IMCOSH
,
IMCOT
,
IMCSC
,
IMCSCH
,
IMDIV
,
IMEXP
,
IMCONJUGATE
,
IMLN
,
IMLOG10
,
IMLOG2
,
IMPRODUCT
,
IMREAL
,
IMSEC
,
IMSECH
,
IMSIN
,
IMSINH
,
IMSQRT
,
IMSUB
,
IMSUM
,
IMTAN
Number Conversion functions
The Number Conversion functions convert numbers between forms.
BIN2DEC
,
BIN2HEX
,
BIN2OCT
,
DEC2BIN
,
DEC2HEX
,
DEC2OCT
,
HEX2BIN
,
HEX2DEC
,
HEX2OCT
,
OCT2BIN
,
OCT2DEC
,
OCT2HEX
ARABIC
,
DECIMAL
,
ROMAN
Information functions
The Information functions return information about cells, such as whether they contain text or a formula, etc.
ERROR.TYPE,
ISBLANK
, ISBINARY,
ISERR
,
ISERROR
,
ISEVEN
,
ISLOGICAL
,
ISNA
,
ISNONTEXT
,
ISNUMBER
,
ISODD
,
ISREF
,
ISTEXT
,
N
,
NA
,
TYPE
Lookup-reference functions
The Lookup-reference functions find values in tables, or cell references.
ARRAYLENGTH,
CHOOSE
, GETARRAYELEMENT,
INDEX
,
INDIRECT
, ISINARRAY,
MATCH
,
OFFSET
Financial functions
The Financial functions provide common business calculations.
DB
,
DDB
,
SLN
,
SYD
CUMIPMT
,
CUMPRINC
,
FV
,
FVSCHEDULE
,
IPMT
,
IRR
,
ISPMT
,
MIRR
,
NPER
,
NPV
,
PMT
,
PPMT
,
PV
,
RATE
,
RRI
,
XIRR
,
XNPV
ACCRINT
,
EFFECT
,
NOMINAL
, PDURATION,
TBILLEQ
,
TBILLPRICE
,
TBILLYIELD
DOLLARDE
,
DOLLARFR
Statistical functions
The Statistical functions provide statistical and probability calculations.
AVEDEV
,
AVERAGE
,
AVERAGEA
, AVERAGEIF, AVERAGEIFS,
COUNT
,
COUNTA
, COLUMN.AT,
COLUMNS
, ROW.AT,
ROWS
, COUNTIN, COUNTIFS, COUNTUNIQUE,
GEOMEAN
,
HARMEAN
,
MEDIAN
,
MODE
, MODE.MULT, MODE.SNGL,
TRIMMEAN
DEVSQ
,
KURT
,
SKEW
, SKEW.P,
STDEV
, STDEV.P, STDEV.S,
STDEVA
,
STDEVPA
,
VAR
, VAR.P, VAR.S,
VARA
,
VARPA
BETADIST
, BETA.DIST,
BETAINV
, BETA.INV,
BINOMDIST
, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV,
CHISQDIST
, CHISQ.DIST, CHISQ.DIST.RT,
CHISQINV
, CHISQ.INV, CHISQ.INV.RT,
CHISQTEST
, CHISQ.TEST,
CONFIDENCE
, CONFIDENCE.NORM, CONFIDENCE.T,
EXPONDIST
, EXPON.DIST,
FDIST
, F.DIST, F.DIST.RT, F.INV, F.INV.RT,
FTEST
, F.TEST,
FISHER
,
FISHERINV
,
GAMMA
,
GAMMADIST
, GAMMA.DIST,
GAMMAINV
, GAMMA.INV,
GAMMALN
, GAMMALN.PRECISE,
GAUSS
,
HYPGEOMDIST
, HYPGEOM.DIST,
LOGINV
,
LOGNORMDIST
, LOGNORM.DIST, LOGNORM.INV,
NEGBINOMDIST
, NEGBINOM.DIST,
NORMDIST
, NORM.DIST,
NORMINV
, NORM.INV,
NORMSDIST
, NORM.S.DIST,
NORMSINV
, NORM.S.INV,
PERMUT
,
PERMUTATIONA
,
PHI
,
POISSON
, POISSON.DIST,
PROB
,
STANDARDIZE
,
TDIST
, T.DIST, T.DIST.2T, T.DIST.RT,
TINV
, T.INV, T.INV.2T,
TTEST
, T.TEST,
WEIBULL
, WEIBULL.DIST,
ZTEST
, Z.TEST
CORREL
,
COVAR
, COVARIANCE, COVARIANCE.P, COVARIANCE.S,
FORECAST
,
INTERCEPT
,
PEARSON
,
RSQ
,
SLOPE
,
STEYX
LARGE
,
MAX
,
MAXA
,
MIN
,
MINA
,
PERCENTILE
, PERCENTILE.EXC, PERCENTILE.INC,
PERCENTRANK
, PERCENTRANK.EXC, PERCENTRANK.INC,
QUARTILE
, QUARTILE.EXC, QUARTILE.INC,
RANK
, RANK.AVG, RANK.EQ,
SMALL
AGGREGATE
Array functions
The Array functions operate on and return entire tables of data.
FREQUENCY
,
GROWTH
,
LINEST
,
LOGEST
,
MDETERM
,
MINVERSE
,
MMULT
,
MUNIT
,
TRANSPOSE
,
TREND
Engineering functions
The Engineering functions provide common engineering calculations.
BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
Miscellaneous functions
The Engineering functions provide common engineering calculations.
UNIQUE, ARGS2ARRAY, REFERENCE, JOIN, NUMBERS
PRODUCT & FEATURES
Form Platform and Form Builder
Questions and Web Elements Library
Table and Spreadsheet
Conditional Logic
Payment Forms
Choice of Payment Methods
Recurring
and
Conditional Payment
Discount Voucher
Save and Resume
Email Notification
Downloadable Receipt
Responsive Design
Multi-tabs Forms
Reusable Forms
No-duplicate Submissions
Royalty Free Fonts and Images
CAPTCHA Protection
RESOURCES
Form Templates
Pricing
FAQ
How-to Guide
Getting Started
Help Center
Blog
Zapof Functions
Choosing Stripe or PayPal
GDPR
COMPANY
About
Contact Us
Terms
|
Privacy
|
Spam Policy
© 2023
Zapof
Created with
Zapof