# 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

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

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