All supported Formulas

This article lists all the formulas that are supported in DronaHQ Studio

ABS

Returns the absolute value of a number
Input: ABS(-20)
Result: 20

ACCRINT

Returns the accrued interest for a security that pays periodic interest
Input: ACCRINT("1/1/2010", "2/1/2010", "12/31/2012",5%,100,4,0)
Result: 14.98611111

ACOS

Returns the arccosine of a number
Input: ACOS(0)
Result: 1.570796327

ACOSH

Returns the inverse hyperbolic cosine of a number
Input: ACOSH(2)
Result: 1.316957897

ACOT

Returns the arccotangent of a number
Input: ACOT(0)
Result: 1.570796327

ACOTH

Returns the hyperbolic arccotangent of a number
Input: ACOTH(2)
Result: 0.5493061443

AGGREGATE

Returns an aggregate in a list or database
Input: aggregate(1,4,LOOKUP(Stocks.in))
Result: 33

AND

Returns TRUE if all of its arguments are TRUE
Input: AND(1=1,8>7) (All true)
Result: TRUE

ARABIC

Converts a Roman number to Arabic, as a number
Input: ARABIC(“XXXIXI”)
Result: 40

ASIN

Returns the arcsine of a number
Input: ASIN(0.5)
Result: 0.5235987756

ASINH

Returns the inverse hyperbolic sine of a number
Input: asinh(2)
Result: 1.443635475

ATAN

Returns the arctangent of a number
Input: ATAN(3.14/2)
Result: 1.003655078

ATAN2

Returns the arctangent from x- and y-coordinates
Input: ATAN2(2,3)
Result: 0.9827937232

ATANH

Returns the inverse hyperbolic tangent of a number
Input: atanh(0.5)
Result: 0.5493061443

AVEDEV

Returns the average of the absolute deviations of data points from their mean
Input: avedev(1,2)
Result: 0.5

AVERAGE

Returns the average of its arguments
Input: AVERAGE(1,2,3)
Result: 2

AVERAGEA

Returns the average of its arguments, including numbers, text, and logical values
Input: AVERAGEA(LOOKUP(Stocks.in,Stocks.out))
Result: 33

AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
Input: AVERAGEIF(LOOKUP(Stocks.in,’>10’)
Result:

AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Input: AVERAGEIFS(LOOKUP(Stocks.in),LOOKUP(Stocks.out),’>10’)
Result: 27.5

BASE

Converts a number into a text representation with the given radix (base)
Input: BASE(8,2,6)
Result: 1000

BESSELI

Returns the modified Bessel function In(x)
Input: BESSELI(1.5,1)
Result: 0.981666

BESSELJ

Returns the Bessel function Jn(x)
Input: BESSELJ(12,2)
Result: -0.08493

BESSELK

Returns the modified Bessel function Kn(x)
Input: BESSELK(80,5)
Result: 2.95E-36

BESSELY

Returns the Bessel function Yn(x)
Input: BESSELY(12,5)
Result: -0.22981795

BIN2DEC

Converts a binary number to decimal
Input: BIN2DEC(1000)
Result: 8

BIN2HEX

Converts a binary number to hexadecimal
Input: BIN2HEX(101,8)
Result: 5

BIN2OCT

Converts a binary number to octal
Input: BIN2OCT(1000,8)
Result: 10

BINOMDIST

Returns the individual term binomial distribution probability
Input: BINOMDIST(3,7,0.5,TRUE)
Result: 0.5

BITAND

Returns a ‘Bitwise And’ of two numbers
Input: BITAND(12,14)
Result: 12

BITXOR

Returns a bitwise ‘Exclusive Or’ of two numbers
Input: BITXOR(9,5)
Result: 12

CEILING

Rounds a number to the nearest integer or to the nearest multiple of significance
Input: CEILING(10,6)
Result: 12

CEILING.MATH

Rounds a number up, to the nearest integer or to the nearest multiple of significance
Input: CEILINGMATH(11,2,1)
Result: 12

CEILINGPRECISE

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
Input: CEILINGPRECISE(12.5,6.2)
Result: 18.6

CHAR

Returns the character specified by the code number
Input: CHAR(80)
Result: P

CHOOSE

Chooses a value from a list of values
Input: CHOOSE(2, “A”, “B”)
Result: B

CLEAN

Removes all nonprintable characters from text
Input: CLEAN(“AF”&CHAR(31))
Result: AF

CODE

Returns a numeric code for the first character in a text string
Input: CODE(“a”)
Result: 97

COLUMN

Returns the column number of a reference
Input: COLUMN(LOOKUP(Stocks.in,Stocks.serialnumber=5))
Result: 5

COLUMNS

Returns the number of columns in a reference
Input: COLUMNS(LOOKUP(Stocks.in,Stocks.out))
Result: 2

CONVERT

Converts a number from one measurement system to another
Input: CONVERT(1000, “g”, “kg”)
Result: 1

CORREL

Returns the correlation coefficient between two data sets
Input: CORREL(LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 0.400516

COS

Returns the cosine of a number
Input: COS(0)
Result: 1

COSH

Returns the hyperbolic cosine of a number
Input: COSH(3.14/3)
Result: 1.599623814

COT

Returns the hyperbolic cosine of a number
Input: COT(0.5)
Result: 1.830487722

COTH

Returns the cotangent of an angle
Input: COTH(3.14/6)
Result: 2.082168237

COUNT

Counts how many numbers are in the list of arguments
Input: COUNT(1,5,7,9)
Result: 4

COUNTA

Counts how many values are in the list of arguments
Input: COUNTA(LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 10

COUNTBLANK

Counts the number of blank cells within a range
Input: COUNTBLANK(LOOKUP(Stocks.in))
Result: 1

COUNTIF

Counts the number of cells within a range that meet the given criteria
Input: COUNTIF(LOOKUP(Stocks.in),’>1’)
Result: 5

CSC

Returns the cosecant of an angle
Input: CSC(3.14/2)
Result: 1.000000317

CSCH

Returns the hyperbolic cosecant of an angle
Input: CSCH(1)
Result: 0.8509181282

CUMIPMT

Returns the cumulative interest paid between two periods
Input: CUMIPMT(1.2%, 12, 100, 1, 5, 0)
Result: -5.052998806

CUMPRINC

Returns the cumulative principal paid on a loan between two periods
Input: CUMPRINC(12%, 12, 100, 1, 5, 0)
Result: -26.32417137

DATE

Returns the serial number of a particular date
Input: DATE(1969, 7, 20)
Result: 7/20/1969

DATEVALUE

Converts a date that is stored as text to a serial number.
Input: DATEVALUE(“1969-7-20”)
Result: 25403.99386574074

DAY

Converts a serial number to a day of the month
Input: DAY(“7/20/1969”)
Result: 20

DAYS

Returns the number of days between two dates
Input: DAYS(“7/24/1969”, “7/16/1969”)
Result: 8

DAYS360

Calculates the number of days between two dates based on a 360-day year
Input: DAYS360(“7/16/1969”, “7/24/1969”, 1)
Result: 8

DB

Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
Input: DB(100, 50, 10, 2, 12)
Result: $6.25

DDB

Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
Input: DDB(100, 50, 10, 2, 2.25)
Result: $17.44

DEC2BIN

Converts a decimal number to binary
Input: DEC2BIN(“100”,8)
Result: 1100100

DECIMAL

Converts a text representation of a number in a given base into a decimal number
Input: DECIMAL(“1000”,2)
Result: 8

DEGREES

Converts radians to degrees
Input: DEGREES(3.14/6)
Result: 29.98479128

DELTA

Tests whether two values are equal
Input: DELTA(8,8)
Result: 1

DEVSQ

Returns the sum of squares of deviations
Input: DEVSQ(1,2)
Result: 0.5

DOLLARDE

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
Input: DOLLARDE(100.1, 32)
Result: 100.3125

DOLLARFR

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
Input: DOLLARFR(100.125, 32)
Result: 100.04

EDATE

Returns the serial number of the date that is the indicated number of months before or after the start date
Input: EDATE(“7/20/1969”, 1)
Result: 25434.99386574074

EFFECT

Returns the effective annual interest rate
Input: EFFECT(3%, 12)
Result: 0.03041595691

EOMONTH

Returns the serial number of the last day of the month before or after a specified number of months.
Syntax: EOMONTH(start_date, months)
Input: EOMONTH(“7/20/1969”, 1)
Result: 25383.99386574074

ERF

Returns the error function
Input: ERF(-2.3, -0.7)
Result: 0.3210556296

ERFC

Returns the complementary error function
Input: ERFC(2)
Result: 0.004677734981

EVEN

Rounds a number up to the nearest even integer
Input: EVEN(135)
Result: 136

EXACT

Checks to see if two text values are identical
Input: EXACT(‘hello’, ‘goodbye’)
Result: FALSE

EXP

Returns e raised to the power of a given number
Input: EXP(5)
Result: 148.4131591

EXPONDIST

Returns the exponential distribution
Input: EXPONDIST(12,1,24)
Result:

FACT

Returns the factorial of a number
Input: FACT(5)
Result: 120

FACTDOUBLE

Returns the double factorial of a number
Input: FACTDOUBLE(5)
Result: 15

FALSE

Returns the logical value FALSE
Input: FALSE()
Result: FALSE

FDIST

Returns the F probability distribution
Input: FDIST(15.35, 7, 6)
Result: 0.001930553432

FDISTRT

Returns the F probability distribution
Input: F.DIST.RT(15.35, 7, 6)
Result: 0.001930553432

FINVRT

Returns the inverse of the F probability distribution
Input: F.INV.RT(0.42, 2, 3)
Result: 1.174597281

FINV

Returns the inverse of the F probability distribution
Input: FINV(0.42, 2, 3)
Result: 1.174597281

FISHER

Returns the Fisher transformation
Input: FISHER(0.962)
Result: 1.97206674

FISHERINV

Returns the inverse of the Fisher transformation
Input: FISHERINV(0.962)
Result: 0.7451676441

FLOOR

Rounds a number down, toward zero
Input: FLOOR(19.89,5)
Result: 15

FORECAST

Returns a value along a linear trend
Input: FORECAST(5,LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: FORECAST(5,LOOKUP(Stocks.in),LOOKUP(Stocks.out))

FREQUENCY

Returns a frequency distribution as a vertical array
Input: FREQUENCY(LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 1

FV

Returns the future value of an investment
Input: FV(2%, 12, 100, 400, 0)
Result: -$1,848.51

GAMMA

Returns the Gamma function value
Input: GAMMA(2)
Result: 1

GCD

Returns the greatest common divisor
Input: GCD(LOOKUP(Stocks.in),
Result: 5

GEOMEAN

Returns the geometric mean
Input: GEOMEAN(1,2)
Result: 1.414213562

GESTEP

Tests whether a number is greater than a threshold value
Input: GESTEP(5, 2)
Result: 1

HARMEAN

Returns the harmonic mean
Input: HARMEAN(1, 2)
Result: 1.333333333

HEX2BIN

Converts a hexadecimal number to binary
Input: HEX2BIN(“F1”,8)
Result: 11110001

HEX2DEC

Converts a hexadecimal number to decimal
Input: HEX2DEC(“FFFFFFFF5B”)
Result: -165

HEX2OCT

Converts a hexadecimal number to octal
Input: HEX2OCT(377)
Result: 1567

HOUR

Returns the hour as a number from 0 to 23
Input: HOUR(TODAY())
Result: 10 (assuming that time is 10:30 AM at that given moment)

HYPGEOMDIST

Returns the hypergeometric distribution
Input: HYPGEOMDIST(4, 12, 20, 40)
Result: 0.1092430027

IF

Specifies a logical test to perform
Input: IF(2>1,TRUE,FALSE)
Result: TRUE

IMABS

Returns the absolute value (modulus) of a complex number
Input: IMABS(“1+2i”)
Result: 2.236067977

IMAGINARY

Returns the imaginary coefficient of a complex number
Input: IMAGINARY(“5+6i”)
Result: 6

IMARGUMENT

Returns the argument theta, an angle expressed in radians
Input: IMARGUMENT(“4+3i”)
Result: 0.6435011088

IMCOSH

Returns the hyperbolic cosine of a complex number
Input: IMCOSH(“4+5i”)
Result: 7.74631300740307-26.1689640538728i

IMCOT

Returns the cotangent of a complex number
Input: IMCOT(“4+3i”)
Result: 0.00490118239430447-0.999266927805902i

IMCSC

Returns the cosecant of a complex number
Input: IMCSC(“3+4i”)
Result: 0.0051744731840194+0.036275889628626i

IMDIV

Returns the quotient of two complex numbers
Input: IMDIV(“2+3i”,“8+5i”)
Result: 0.348314606741573+0.157303370786517i

IMEXP

Returns the exponential of a complex number
Input: IMEXP(“4+3i”)
Result: -54.0517588610782+7.70489137273115i

IMLN

Returns the natural logarithm of a complex number
Input: IMLN(“4+3i”)
Result: 1.6094379124341+0.643501108793284i

IMLOG10

Returns the base-10 logarithm of a complex number
Input: IMLOG10(“4-3i”)
Result: 0.698970004336019-0.279468980647547i

IMLOG2

Returns the base-2 logarithm of a complex number
Input: IMLOG2(“4+4i”)
Result: 2.5+1.1330900354568i

IMPOWER

Returns a complex number raised to an integer power
Input: IMPOWER(“4+3i”,2)
Result: 7+24i

IMPRODUCT

Returns the product of complex numbers
Input: IMPRODUCT(“4+3i”,“4+3i”)
Result: 7+24i

IMREAL

Returns the real coefficient of a complex number
Input: IMREAL(“45+67i”)
Result: 45

IMSEC

Returns the secant of a complex number
Input: IMSEC(“12+48i”)
Result: 2.4052607061286E-21-1.52940890101143E-21i

IMSECH

Returns the hyperbolic secant of a complex number
Input: IMSECH(“4+3i”)
Result: -0.0362534969158689-0.00516434460775318i

IMSIN

Returns the sine of a complex number
Input: IMSIN(“4+3i”)
Result: -7.61923172032141-6.548120040911i

IMSINH

Returns the hyperbolic sine of a complex number
Input: IMSINH(“12+12i”)
Result: 68670.6375182113-43664.906676772i

IMSUB

Returns the difference between two complex numbers
Input: IMSUB(“4+3i”,“4-3i”)
Result: 6i

IMSUM

Returns the sum of complex numbers
Input: IMSUM(“4+3i”,“4+3i”)
Result: 8+6i

IMTAN

Returns the tangent of a complex number
Input: IMTAN(“4+3i”)
Result: 0.00490825806749606+1.00070953606723i

INT

Rounds a number down to the nearest integer
Input: INT(52.63)
Result: 52

INTERCEPT

Returns the intercept of the linear regression line
Input: INTERCEPT(LOOKUP((Stocks.in),LOOKUP(Stocks.out))
Result: 27.05997

IPMT

Returns the interest payment for an investment for a given period
Input: IPMT(1%, 1, 360, 100000, 30000, 0)
Result: -$1,000.00

IRR

Returns the internal rate of return for a series of cash flows
Input: IRR(LOOKUP(Fetch_new.irr),0.01)
Result: -0.35

ISEVEN

Returns TRUE if the number is even
Input: ISEVEN(6)
Result: TRUE

ISLOGICAL

Returns TRUE if the value is a logical value
Input: ISLOGICAL(LOOKUP(Stocks.in))
Result: FALSE

ISNONTEXT

Returns TRUE if the value is not text
Input: ISNONTEXT(LOOKUP(Stocks.in))
Result: TRUE

ISNUMBER

Returns TRUE if the value is a number
Input: ISNUMBER(889)
Result: TRUE

ISODD

Returns TRUE if the number is odd
Input: ISODD(52)
Result: FALSE

ISTEXT

Returns TRUE if the value is text
Input: ISTEXT(“qwe”)
Result: TRUE

ISOWEEKNUM

Returns the number of the ISO week number of the year for a given date
Input: ISOWEEKNUM(“7/20/1969”)
Result: 29

ISPMT

Calculates the interest paid during a specific period of an investment
Input: ISPMT(15%, 2, 5, 1000)
Result: -90

KURT

Returns the kurtosis of a data set
Input: KURT(1,2,3,4)
Result: -1.2

LARGE

Returns the k-th largest value in a data set
Input: LARGE(LOOKUP(Stocks.in),1)
Result: 60

LCM

Returns the least common multiple
Input: lcm(1,5,9,86)
Result: 3870

LINEST

Returns the parameters of a linear trend
Input: LINEST(LOOKUP(Stocks.in),LOOKUP(Stocks.out),TRUE,FALSE)
Result: 0.20482866

LN

Returns the natural logarithm of a number
Input: LN(2)
Result: 0.6931471806

LOG

Returns the logarithm of a number to a specified base
Input: LOG(5,10)
Result: 0.6989700043

LOG10

Returns the base-10 logarithm of a number
Input: LOG10(2)
Result: 0.3010299957

LOGEST

Returns the parameters of an exponential trend
Input: LOGEST(LOOKUP(Stocks.in),LOOKUP(Stocks.out),TRUE,FALSE)
Result: 1.007655

LOGNORMDIST

Returns the cumulative lognormal distribution
Input: LOGNORMDIST(4, 4, 6)
Result: 0.3315570972

LOGNORMINV

Returns the inverse of the lognormal cumulative distribution
Input: LOGNORMINV(0.5,2,0.3)
Result: 7.389056

LOWER

Converts text to lowercase
Input: LOWER(“QWEWEQWE”)
Result: qweweqwe

MAX

Returns the maximum value in a list of arguments
Input: MAX(1,2,3,4,5)
Result: 5

MAXA

Returns the maximum value in a list of arguments, including numbers, text, and logical values
Input: MAXA(2,LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 200

MEDIAN

Returns the median of the given numbers
Input: MEDIAN(LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 20

MID

Returns a specific number of characters from a text string starting at the position you specify
Input: MID(“Today is Wednesday”,6,20)
Result: is Wednesday

MIN

Returns the minimum value in a list of arguments
Input: MIN(LOOKUP(Stocks.in))
Result: 5

MINUTE

Converts a serial number to a minute
Input: MINUTE(TODAY())
Result: 30 (assuming for the sake of example that time is 10:30 AM at that given moment)

MIRR

Returns the internal rate of return where positive and negative cash flows are financed at different rates
Input: MIRR(LOOKUP(Fetch_new.irr),2%,8%)
Result: -0.26

MOD

Returns the remainder from division
Input: MOD(10,4)
Result: 2

MODEMULT

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
Input: MODEMULT(100,LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 100

MODESNGL

Returns the most common value in a data set
Input: MODESNGL(100,LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result: 100

MONTH

Converts a serial number to a month
Input: MONTH(“7/20/1969”)
Result: 7
Also,
Input: MONTH(78866)
Result: 12

MROUND

Returns a number rounded to the desired multiple
Input: MROUND(21, 14)
Result: 28

MULTINOMIAL

Returns the multinomial of a set of numbers
Input: MULTINOMIAL(1,2)
Result: 3

NEGBINOMDIST

Returns the negative binomial distribution
Input: NEGBINOMDIST(4, 2, 0.1)
Result: 0.032805

NETWORKDAYS

Returns the number of whole workdays between two dates
Syntax: NETWORKDAYS(start_date, end_date, [holidays])
Input: NETWORKDAYS(“7/16/1969”,“7/24/1969”,LOOKUP(FormulaTest.date)
Result: 3

NOMINAL

Returns the annual nominal interest rate
Input: NOMINAL(4%, 12)
Result: 0.03928487739

NOW

Returns the current date and time.
Input: NOW()
Result: Wed Jan 09 2019 19:42:16 GMT+0530 (India Standard Time)

OCT2BIN

Converts an octal number to binary
Input: OCT2BIN(37,5)
Result: 11111

OCT2DEC

Converts an octal number to decimal
Input: OCT2DEC(37,5)
Result: 0001F

OCT2HEX

Converts an octal number to hexadecimal
Input: OCT2HEX(37,5)
Result: 0001F

ODD

Rounds a number up to the nearest odd integer
Input: odd(9998)
Result: 9999

OR

Returns TRUE if any argument is TRUE
Input: OR(2=6,5>6)
Result: FALSE

PMT

Returns the periodic payment for an annuity
Input: PMT(10%/12,20*12,2500000)
Result: -$24,125.54

POWER

Returns the result of a number raised to a power
Input: power(2,-3)
Result: 0.125

PRODUCT

Multiplies its arguments
Input: PRODUCT(1,2,3,4,5)
Result: 120

PROPER

Capitalizes the first letter in each word of a text value
Input: PROPER(“new year”)
Result: New Year

RANKAVG

Returns the rank of a number in a list of numbers
Input: RANKAVG(10,LOOKUP(Stocks.out),TRUE)
Result: 2

RIGHT

Returns the rightmost characters from a text value
Input: RIGHT(“Today is Wednesday”,10)
Result: Wednesday

ROMAN

Converts an Arabic numeral to roman, as text
Input: roman(50,4)
Result: L

ROUND

Rounds a number to a specified number of digits
Input: round(12.456829,5)
Result: 12.45683

ROUNDDOWN

Rounds a number down, toward zero
Input: ROUNDDOWN(16.657567567,5)
Result: 16.65756

ROUNDUP

Rounds a number up, away from zero
Input: ROUNDUP(99.02,1)
Result: 99.1

SEARCH

Finds one text value within another (not case-sensitive)
Input: SEARCH(“ghh”,“rklklghhyug”,2)
Result: 6

SEC

Returns the secant of an angle
Input: SEC(3.14)
Result: -1.000001268

SECH

Returns the hyperbolic secant of an angle
Input: SECH(9)
Result: 0.0002468196044

SECOND

Converts a serial number to a second
Input: SECOND(“11:40:59 AM”)
Result: 59

SERIESSUM

Returns the sum of a power series based on the formula
Input: SERIESSUM(2,3,1,5)
Result: 40

SIN

Returns the sine of the given angle
Input: SIN(90)
Result: 0.8939966636

SINH

Returns the hyperbolic sine of a number
Input: SINH(5)
Result: 74.20321058

STANDARDIZE

Returns a normalized value
Input: STANDARDIZE(90,56,7.9)
Result: 4.303797468

STDEVS

Estimates standard deviation based on a sample
Input: STDEVS(1,5,7,8)
Result:

STDEVA

Estimates standard deviation based on a sample, including numbers, text, and logical values
Input: STDEVA(1,5,7,6)
Result: 2.62995564

STDEVP

Calculates standard deviation based on the entire population
Input: STDEVP(1,5,7,6)
Result: 2.277608395

STDEVPA

Calculates standard deviation based on the entire population, including numbers, text, and logical values
Input: STDEVPA(1,5,7,8)
Result: 2.680951324

SUM

Adds its arguments
Input: SUM(1,2,3)
Result: 6

SUMIF

Adds the cells specified by a given criteria
Input: SUMIF({1,2,3,4,5},"<5")
Result: 10

SUMSQ

Returns the sum of the squares of the arguments
Input: SUMSQ(453,545)
Result: 502234

T

Converts its arguments to text
Input: T(“QWErty”)
Result: QWErty

TAN

Returns the tangent of a number
Input: TAN(PI/2)
Result: 16331200000000000

TANH

Returns the hyperbolic tangent of a number
Input: TANH(1)
Result: 0.761594156

TIME

Returns the serial number of a particular time
Input: TIME(11, 40, 59)
Result: 0.486793981481481

TIMEVALUE

Converts a time in the form of text to a serial number
Input: TIMEVALUE(TODAY())
Result: 0.538912037037037

TODAY

Returns the Current or Today’s date
Input: TODAY()
Result: 2020-07-22T08:00:25.406Z

TRIM

Removes spaces from text
Input: TRIM(“lorem ipsum”)
Result: lorem ipsum

TRUE

Returns the logical value TRUE
Input: NOT(TRUE)
Result: FALSE

TRUNC

Truncates a number to an integer
Input: TRUNC(3.141592654, 2)
Result: 3.14

UNICODE

Returns the number (code point) that corresponds to the first character of the text
Input: UNICODE(“Alphabet”)
Result: 65

UNIQUE

Returns a list of unique values in a list or range
Input: UNIQUE(LOOKUP(Stocks.in))

UPPER

Converts text to uppercase
Input: upper(“werewrrw”)
Result: WEREWRRW

WEEKDAY

Converts a serial number to a day of the week where the return type specifies the first day of the week. For example: 2 means weekdays are numbered as Numbers 1 (Monday) through 7 (Sunday). 3 means weekdays are numbered as Numbers 0(Monday) through 6 (Sunday).
Input: WEEKDAY(“7/20/2020”, 2)
Result: 4

WEEKNUM

Converts a serial number to a number representing where the week number is numerically within a year
Input: WEEKNUM(“8/20/2020”, 1)
Result: 34
Input: WEEKNUM(7774577)
Result: 4

XNPV

Returns the net present value for a schedule of cash flows that is not necessarily periodic
Input: XNPV(8%,LOOKUP(Stocks.in),LOOKUP(Stocks.out))
Result:

XOR

Returns a logical exclusive OR of all arguments
Input: XOR(1=2, 3>5) (All false)
Result: FALSE

YEAR

Converts a serial number to a year
Input: YEAR(1999)
Result: 1905

YEARFRAC

Returns the year fraction representing the number of whole days between start_date and end_date
Input: YEARFRAC(“7/16/1969”, “7/16/2019”, 1)
Result: 50

JSON Store control - deprecated
Line Graph control - control is now deprecated
Toggle Button control
Dropdown control
Form Repeat control
Rich Text Viewer control
Dual Text control
Grid Menu control
HTML control
Table Grid control
Progress Bar Control
Rich Text Editor control
Media Player control
Time Picker control
Date & Time Picker control
Form MultiRow control
Multi Image control
Detail View control
Pagination in Tablegrid Control
Label control
Formula Column
Popular Date and Time formulas
Statistics control
Input Label control
Checkboxes control
Text control
Split Button control
Numeric Control
Action Button control
Date Picker control
Nav Bar Control
Map control
Currency control
Image Slider control
Address control
Value Picker control
Keyword Box control
Quantity control
Data Store control
Heading control
Name control
Image control
Menu List control
Donut charts control
OTP Control
Pie Chart control
Prefix and Suffix control
Circular Progress Bar Control
Important Functions
Tag Control
Sortable Control
Using Pagination in Table grid control
Stripe Control
Embed Control
Profile Group
Radio Control
Tagged Content control
Rating control
Barcode control
Tagged Images control
Range Picker control
Google Doc Viewer Control
Textarea control
Metric Control
Calculate Time Difference
BPM Submit Control
Sparkline control
Dashboard control
Text Input control
Column Graph control
Bar Graph control
Select bar control
NFC Reader Control
Select control
Area Graph control
Detail Select control
Pagination Control
Calendar Control
File Parser control
Using a calculated value in place of columnar data
Text Suggestion control
Breadcrumbs Control
Advance Map control
Advanced Dropdown control
Phone control
Collapsible Menu control