functions.js

functions.js
¶

Copyright 2015-2021 JC Fisher
¶

Formula’s Functions
¶

Functions

The library includes functions for logic, math, text, lookup, date/time, aggregation, arrays, objects, finance, statistics and other utilities.

Formula

export { default as ERROR } from "./error";
export { ERRORTYPES } from "./error";

parser

walker converts an AST into a function.

export { default as PARSE } from "./parser";
export { default as parse } from "./parser";

walker

walker converts an AST by walking and applying the config.

export { default as WALKER } from "./walker";
export { defaultConfig as WALKERCONFIGDEFAULT } from "./walker";
export { fpConfig as WALKERCONFIGFP } from "./walker";
export { jsConfig as WALKERCONFIGJS } from "./walker";

compile

compile converts a formula expression into a runnable JavaScript function.

export { default as COMPILE } from "./compile";
export { default as compile } from "./compile";

run

run execute a formula once.

export { default as RUN } from "./run";
export { default as run } from "./run";

¶

LogicalRUN

branch

branch is equivalent to if-elseif-else.

export { default as BRANCH } from "./branch";
export { default as IF } from "./branch";
export { default as IFS } from "./branch";
export { default as branch } from "./branch";
export { default as ifs } from "./branch";
export { default as if } from "./branch";

choose

choose returns value from index_value from argument list.

export { default as CHOOSE } from "./choose";
export { default as choose } from "./choose";

Switch

switch is equivalent to switch case.

export { default as SWITCH } from "./switch";
export { default as switch } from "./switch";

and

and returns true when all arguments are true or evaluates to true.

export { default as AND } from "./and";
export { default as and } from "./and";

nand

nand returns composition not(and(...))

export { default as NAND } from "./nand";
export { default as nand } from "./nand";

or

or returns true when any argument is true or evaluates to true.

export { default as OR } from "./or";
export { default as or } from "./or";

nor

nor returns composition not(or(...))

export { default as NOR } from "./nor";
export { default as nor } from "./nor";

xor

xor returns the logical exclusive Or of all arguments.

export { default as XOR } from "./xor";
export { default as xor } from "./xor";

not

not returns the inverse.

export { default as NOT } from "./not";
export { default as not } from "./not";

¶

eq

eq returns true when the first and second arguments are equivalent. String comparision is case insensitive.
```
export { default as EQ } from "./eq";
export { default as eq } from "./eq";
```
¶

ne

ne returns true when the first and second arguments are not equivalent. String comparision is case insensitive.
```
export { default as NE } from "./ne";
export { default as ne } from "./ne";
```

gt

gt returns true when first argument is greater than the second.

export { default as GT } from "./gt";
export { default as gt } from "./gt";

gte

gte returns true when first argument is greater than or equal to the second.

export { default as GTE } from "./gte";
export { default as gte } from "./gte";

lt

lt returns true when first argument is less than the second.

export { default as LT } from "./lt";
export { default as lt } from "./lt";

lte

lte returns true when first argument is less than or equal to the second.

export { default as LTE } from "./lte";
export { default as lte } from "./lte";

identity

identity returns the first argument.

export { default as IDENTITY } from "./identity";
export { default as identity } from "./identity";

ifblank

ifempty returns the second argument when the first argument is blank or the third argument

export { default as IFBLANK } from "./ifblank";
export { default as ifBlank } from "./ifblank";
export { default as ifblank } from "./ifblank";

ifempty

ifempty returns the second argument when the first argument is empty or the third argument

export { default as IFEMPTY } from "./ifempty";
export { default as ifEmpty } from "./ifempty";
export { default as ifempty } from "./ifempty";

iferror

ifempty returns the second argument when the first argument is an error or the third argument

export { default as IFERROR } from "./iferror";
export { default as ifError } from "./iferror";
export { default as iferror } from "./iferror";

ifna

ifempty returns the second argument when the first argument is #NA! or the third argument

export { default as IFNA } from "./ifna";
export { default as ifNA } from "./ifna";
export { default as ifna } from "./ifna";

isarray

isarray returns true when the value is an array.

export { default as ISARRAY } from "./isarray";
export { default as isArray } from "./isarray";
export { default as isarray } from "./isarray";

isasyncfunction

isasyncfunction returns true when the value is a async function.

export { default as ISASYNCFUNCTION } from "./isasyncfunction";
export { default as isAsyncFunction } from "./isasyncfunction";
export { default as isasyncfunction } from "./isasyncfunction";

isblank

isblank returns true when the value is undefined or null.

export { default as ISBLANK } from "./isblank";
export { default as isBlank } from "./isblank";
export { default as isblank } from "./isblank";

isboolean

isboolean returns true when the value is true or false.

export { default as ISBOOLEAN } from "./isboolean";
export { default as isBoolean } from "./isboolean";
export { default as isboolean } from "./isboolean";

isdate

isdate returns true when the value is a JavaScript Date object.

export { default as ISDATE } from "./isdate";
export { default as isDate } from "./isdate";
export { default as isdate } from "./isdate";

isemail

isdate returns true when the value matches the pattern for a valid email address.

export { default as ISEMAIL } from "./isemail";
export { default as isEmail } from "./isemail";
export { default as isemail } from "./isemail";

isempty

isempty returns true when the value is blank or empty string.

export { default as ISEMPTY } from "./isempty";
export { default as isEmpty } from "./isempty";
export { default as isempty } from "./isempty";

iserror

iserror returns true when the value is an error value.

export { default as ISERROR } from "./iserror";
export { default as isError } from "./iserror";
export { default as iserror } from "./iserror";

iseven

iseven returns true when the value is an even number.

export { default as ISEVEN } from "./iseven";
export { default as isEven } from "./iseven";
export { default as iseven } from "./iseven";

isfalsy

isfalsy returns true when value is a string.

export { default as ISFALSY } from "./isfalsy";
export { default as isFalsy } from "./isfalsy";
export { default as isfalsy } from "./isfalsy";

isfunction

isfunction returns true when the value is a function or async function.

export { default as ISFUNCTION } from "./isfunction";
export { default as isFunction } from "./isfunction";
export { default as isfunction } from "./isfunction";

isleapyear

isfunction returns true when the value is a leap year.

export { default as ISLEAPYEAR } from "./isleapyear";
export { default as isLeapYear } from "./isleapyear";
export { default as isleapyear } from "./isleapyear";

islowercase

islowercase returns true when the value is lower case.

export { default as ISLOWERCASE } from "./islowercase";
export { default as isLowerCase } from "./islowercase";
export { default as islowercase } from "./islowercase";

isobject

isobject return true when object exists and is object or function.

export { default as ISOBJECT } from "./isobject";
export { default as isObject } from "./isobject";

isna

isna returns true when the value is #NA!.

export { default as ISNA } from "./isna";
export { default as isNA } from "./isna";
export { default as isna } from "./isna";

isnan

isnan returns true when the value is NaN.

export { default as ISNAN } from "./isnan";
export { default as isNaN } from "./isnan";
export { default as isnan } from "./isnan";

isnumber

isnumber returns true when the value is JavaScript number type and not NaN and not infinite.

export { default as ISNUMBER } from "./isnumber";
export { default as isNumber } from "./isnumber";
export { default as isnumber } from "./isnumber";

isodd

isodd returns true when the value is an odd number.

export { default as ISODD } from "./isodd";
export { default as isOdd } from "./isodd";
export { default as isodd } from "./isodd";

isoweeknum

isoweeknum returns number of the ISO week number of the year for a given date.

export { default as ISOWEEKNUM } from "./isoweeknum";
export { default as ISOWeekNum } from "./isoweeknum";
export { default as isoweeknum } from "./isoweeknum";

ispromise

ispromise returns true when value is a ref object.

export { default as ISPROMISE } from "./ispromise";
export { default as isPromise } from "./ispromise";
export { default as ispromise } from "./ispromise";

isref

isref returns true when value is a ref object.

export { default as ISREF } from "./isref";
export { default as isRef } from "./isref";
export { default as isref } from "./isref";

istext

istext returns true when value is a string.

export { default as ISTEXT } from "./istext";
export { default as isText } from "./istext";

istruthy

istruthy returns true when value is a string.

export { default as ISTRUTHY } from "./istruthy";
export { default as isTruthy } from "./istruthy";
export { default as istruthy } from "./istruthy";

isuppercase

isuppercase returns true when the value is lower case.

export { default as ISUPPERCASE } from "./isuppercase";
export { default as isUpperCase } from "./isuppercase";
export { default as isuppercase } from "./isuppercase";

isurl

isurl returns true when value matches a url pattern.

export { default as ISURL } from "./isurl";
export { default as isURL } from "./isurl";
export { default as isurl } from "./isurl";

iswholenumber

iswholenumber returns true when value is an integer.

export { default as ISWHOLENUMBER } from "./iswholenumber";
export { default as isWholeNumber } from "./iswholenumber";
export { default as iswholenumber } from "./iswholenumber";

¶

Math functions

minus

minus negates a value.

export { default as MINUS } from "./minus";
export { default as minus } from "./minus";

plus

plus converts value to number.

export { default as PLUS } from "./plus";
export { default as plus } from "./plus";

add

add sums the first and second arguments.

export { default as ADD } from "./add";
export { default as add } from "./add";

subtract

subtract returns the difference between the first and second arguments.

export { default as SUBTRACT } from "./subtract";
export { default as subtract } from "./subtract";

multiply

multiply returns the product of the first and second arguments.

export { default as MULTIPLY } from "./multiply";
export { default as multiply } from "./multiply";

divide

divide returns the result of the first argument divided by the second.

export { default as DIVIDE } from "./divide";
export { default as divide } from "./divide";

abs

abs returns the absolute value of the first argument.

export { default as ABS } from "./abs";
export { default as abs } from "./abs";

acos

acos returns the inverse cosine of a number.

export { default as ACOS } from "./acos";
export { default as acos } from "./acos";

acosh

acosh returns the hyperbolic inverse cosine of a number.

export { default as ACOSH } from "./acosh";
export { default as acosh } from "./acosh";

acot

/ acot returns the arccotangent of a given number.

export { default as ACOT } from "./acot";
export { default as acot } from "./acot";

acoth

/ acot returns the hyperbolic arccotangent of a given number.

export { default as ACOTH } from "./acoth";
export { default as acoth } from "./acoth";

asin

/ asin returns the arccosin of a given number.

export { default as ASIN } from "./asin";
export { default as asin } from "./asin";

asinh

/ asinh returns the hyperbolic arccosin of a given number.

export { default as ASINH } from "./asinh";
export { default as asinh } from "./asinh";

atan

/ atan returns the arctangent of a given number.

export { default as ATAN } from "./atan";
export { default as atan } from "./atan";

atan2

/ atan2 returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.

export { default as ATAN2 } from "./atan2";
export { default as atan2 } from "./atan2";

atanh

/ atanh returns the arctangent (in radians) of the given number.

export { default as ATANH } from "./atanh";
export { default as atanh } from "./atanh";

cos

/ cos returns the cosine of a number

export { default as COS } from "./cos";
export { default as cos } from "./cos";

degrees

/ degrees returns radians converted to degrees.

export { default as DEGREES } from "./degrees";
export { default as degrees } from "./degrees";

mod

export { default as MOD } from "./mod";
export { default as mod } from "./mod";

pi

export { default as PI } from "./pi";
export { default as pi } from "./pi";

power

power returns the nth power of a number.

export { default as POWER } from "./power";
export { default as power } from "./power";

round

round returns a number rounded to a precision.

export { default as ROUND } from "./round";
export { default as round } from "./round";

roundup

roundup returns a number rounded up to a precision.

export { default as ROUNDUP } from "./roundup";
export { default as roundUp } from "./roundup";
export { default as roundup } from "./roundup";

sin

sin return the sinine of a number.

export { default as SIN } from "./sin";
export { default as sin } from "./sin";

tan

tan returns the tangent of a number.

export { default as TAN } from "./tan";
export { default as tan } from "./tan";

tau

export { default as TAU } from "./tau";
export { default as tau } from "./tau";

trunc

trunc returns a number truncated to a given precision.

export { default as TRUNC } from "./trunc";
export { default as trunc } from "./trunc";

within

within(value, lower, upper) returns true when value is between lower and upper.

export { default as WITHIN } from "./within";
export { default as withIn } from "./within";
export { default as within } from "./within";

¶

Text

char

char returns a character given an ASCII code.

export { default as CHAR } from "./char";
export { default as char } from "./char";

camelcase

camelcase returns text converted to camel case.

export { default as CAMELCASE } from "./camelcase";
export { default as camelCase } from "./camelcase";
export { default as camelcase } from "./camelcase";

code

code returns the ASCII code for a given character.

export { default as CODE } from "./code";
export { default as code } from "./code";

concatenate

concatenate combines multiple values into a string.

export { default as CONCATENATE } from "./concatenate";
export { default as concatenate } from "./concatenate";

exact

exact compares two values for strict equivalence.

export { default as EXACT } from "./exact";
export { default as exact } from "./exact";

find

find searches a string for a value and returns the index.

export { default as FIND } from "./find";
export { default as find } from "./find";

join

join combines an array of values into a string with a given delimiter.

export { default as JOIN } from "./join";
export { default as join } from "./join";

left

left returns a given number of characters from the left side of a string.

export { default as LEFT } from "./left";
export { default as left } from "./left";

len

len returns the size of a string of array.

export { default as LEN } from "./len";
export { default as len } from "./len";

lower

lower converts text to lower case.

export { default as LOWER } from "./lower";
export { default as lower } from "./lower";

numbervalue

numbervalue converts text into a number.

export { default as NUMBERVALUE } from "./numbervalue";
export { default as numberValue } from "./numbervalue";
export { default as numbervalue } from "./numbervalue";

parsebool

parsebool converts text into a boolean value.

export { default as PARSEBOOL } from "./parsebool";
export { default as parseBool } from "./parsebool";
export { default as parsebool } from "./parsebool";

parsedate

parsedate converts text into a JavaScript date object

export { default as PARSEDATE } from "./parsedate";
export { default as parseDate } from "./parsedate";
export { default as parsedate } from "./parsedate";

parsequery

parsequery returns a JSObject for a URL query string.

export { default as PARSEQUERY } from "./parsequery";
export { default as parseQuery } from "./parsequery";
export { default as parsequery } from "./parsequery";

proper

proper returns a string as a proper name.

export { default as PROPER } from "./proper";
export { default as proper } from "./proper";

replace

replace returns a string where one value is replaced with a new value.

export { default as REPLACE } from "./replace";
export { default as replace } from "./replace";

right

right returns a given number of characters from the right of a string.

export { default as RIGHT } from "./right";
export { default as right } from "./right";

rept

rept returns a string with a given value repeated n times.

export { default as REPT } from "./rept";
export { default as rept } from "./rept";

¶

search

search returns the index of a value inside a string with wildcard support for single characters (?) and multiple characters (*).
```
export { default as SEARCH } from "./search";
export { default as search } from "./search";
```

snakecase

snakecase returns text converted to snake case.

export { default as SNAKECASE } from "./snakecase";
export { default as snakeCase } from "./snakecase";
export { default as snakecase } from "./snakecase";

substitute

substitute returns a new string with every instance of value replaced.

export { default as SUBSTITUTE } from "./substitute";
export { default as substitute } from "./substitute";

substituteAll

substituteAll returns a new string with every instance of set of values replaced.

export { default as SUBSTITUTEALL } from "./substituteAll";
export { default as substituteAll } from "./substituteAll";
export { default as substituteall } from "./substituteAll";

surroundKeys

surroundKeys returns a new object where the keys have been wrapped with start and end strings.

export { default as SURROUNDKEYS } from "./surroundKeys";
export { default as surroundKeys } from "./surroundKeys";
export { default as surroundkeys } from "./surroundKeys";

split

split returns an array of strings from a given string separated by a delimiter.

export { default as SPLIT } from "./split";
export { default as split } from "./split";

text

text formats numbers and dates using a format code.

export { default as TEXT } from "./text";
export { default as text } from "./text";

trim

trim returns a value with the whitespace removed from the left and right.

export { default as TRIM } from "./trim";
export { default as trim } from "./trim";

upper

upper returns a value in all upper case.

export { default as UPPER } from "./upper";
export { default as upper } from "./upper";

¶

Lookup and reference

hlookup

hlookup searches the first row and returns the value from the found column at a given row.

export { default as HLOOKUP } from "./hlookup";
export { default as hlookup } from "./hlookup";

includes

includes searches an array and returns the true or false for exact matches.

export { default as INCLUDES } from "./includes";
export { default as includes } from "./includes";

notincludes

notincludes searches an array and returns the true or false for exact matches.

export { default as NOTINCLUDES } from "./notincludes";
export { default as notIncludes } from "./notincludes";
export { default as notincludes } from "./notincludes";

index

index returns the value for a given row and column.

export { default as INDEX } from "./index";
export { default as index } from "./index";

¶

lookup

lookup searches an array and returns the value found or (optionally) the value at the same index in a second array.
```
export { default as LOOKUP } from "./lookup";
export { default as lookup } from "./lookup";
```
¶

match

match searches an array and returns the found index with support for wildcard and range queries.
```
export { default as MATCH } from "./match";
export { default as match } from "./match";
```

vlookup

vlookup searches the first column and returns the value from the found row at a given column.

export { default as VLOOKUP } from "./vlookup";
export { default as vlookup } from "./vlookup";

¶

Date manipulation

date

date returns a serial number for a given year, month and day.

export { default as DATE } from "./date";
export { default as date } from "./date";

datevalue

datevalue returns a serial number for a given date string.

export { default as DATEVALUE } from "./datevalue";
export { default as datevalue } from "./datevalue";

datedif

datedif returns the difference between two dates with support for multiple units.

export { default as DATEDIF } from "./datedif";
export { default as datedif } from "./datedif";

day

day returns the day part from a date or date string.

export { default as DAY } from "./day";
export { default as day } from "./day";

days360

days360 returns the days behind two dates using a 360 day year.

export { default as DAYS360 } from "./days360";
export { default as days360 } from "./days360";

¶

edate

edate returns the serial number for a date that is a given number of months before or after a given date.
```
export { default as EDATE } from "./edate";
export { default as edate } from "./edate";
```

eomonth

eomonth returns the last day of the month in future or past months.

export { default as EOMONTH } from "./eomonth";
export { default as eomonth } from "./eomonth";

hour

hour returns the hour part of a time fraction value.

export { default as HOUR } from "./hour";
export { default as hour } from "./hour";

minute

minute returns the minute part of a time fraction value.

export { default as MINUTE } from "./minute";
export { default as minute } from "./minute";

month

month returns the month for a given date.

export { default as MONTH } from "./month";
export { default as month } from "./month";

now

now returns the current date time in a serial number and time fraction.

export { default as NOW } from "./now";
export { default as now } from "./now";

second

second return the second part of a time fraction

export { default as SECOND } from "./second";
export { default as second } from "./second";

today

today returns a serial number for the current date.

export { default as TODAY } from "./today";
export { default as today } from "./today";

time

time returns a time fraction for an hour, minute and second.

export { default as TIME } from "./time";
export { default as time } from "./time";

timevalue

timevalue returns a time fraction given a text value.

export { default as TIMEVALUE } from "./timevalue";
export { default as timevalue } from "./timevalue";

year

year return the year for a given date.

export { default as YEAR } from "./year";
export { default as year } from "./year";

yearfrac

yearfrac calculates the fraction of a year between two dates.

export { default as YEARFRAC } from "./yearfrac";
export { default as yearfrac } from "./yearfrac";

¶

Aggregation

average

average returns the sum divided by the number of items.

export { default as AVERAGE } from "./average";
export { default as average } from "./average";

min

min returns the smallest value in an array.

export { default as MIN } from "./min";
export { default as min } from "./min";

max

min returns the largest value in an array.

export { default as MAX } from "./max";
export { default as max } from "./max";

query

min returns the largest value in an array.

export { default as QUERY } from "./query";
export { default as query } from "./query";

sum

sum returns the value of all items in an array added together.

export { default as SUM } from "./sum";
export { default as sum } from "./sum";

¶

Finance

accrint

accrint teturns the accrued interest for a security that pays periodic interest.

export { default as ACCRINT } from "./accrint";
export { default as accrint } from "./accrint";

fv

fv returns the future value of an investment.

export { default as FV } from "./fv";
export { default as fv } from "./fv";

nper

nper returns the number of periods for an investment.

export { default as NPER } from "./nper";
export { default as nper } from "./nper";

npv

npv returns the net present value of an investment.

export { default as NPV } from "./npv";
export { default as npv } from "./npv";

pmt

pmt returns the amortized payment for a loan.

export { default as PMT } from "./pmt";
export { default as pmt } from "./pmt";

cumipmt

cumipmt returns the cumulative interest on a loan between start and end period.

export { default as CUMIPMT } from "./cumipmt";
export { default as cumipmt } from "./cumipmt";

¶

ipmt

ipmt returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
```
export { default as IPMT } from "./ipmt";
export { default as ipmt } from "./ipmt";
```

pv

pv returns the present value of an investment.

export { default as PV } from "./pv";
export { default as pv } from "./pv";

¶

Engineering

bin2dec

bin2dec converts a binary number into a decimal value.

export { default as BIN2DEC } from "./bin2dec";
export { default as bin2dec } from "./bin2dec";

dec2bin

dec2bin converts a decimal value to a binary string.

export { default as DEC2BIN } from "./dec2bin";
export { default as dec2bin } from "./dec2bin";

oct2dec

oct2dec converts an octal string to a decimal value.

export { default as OCT2DEC } from "./oct2dec";
export { default as oct2dec } from "./oct2dec";

¶

Arrays

filter

filter limits a range based on arrays of true/false values.

export { default as FILTER } from "./filter";
export { default as filter } from "./filter";

flatten

flatten returns an array with values flatten into a single dimension.

export { default as FLATTEN } from "./flatten";
export { default as flatten } from "./flatten";

map

map returns an array mapped to new values with a given function.

export { default as MAP } from "./map";
export { default as map } from "./map";

pluck

pluck returns an array with a property plucked from an array of objects.

export { default as PLUCK } from "./pluck";
export { default as pluck } from "./pluck";

reduce

reduce converts an array into a value.

export { default as REDUCE } from "./reduce";
export { default as reduce } from "./reduce";

some

some returns true if some of the values in an array match the criteria.

export { default as SOME } from "./some";
export { default as some } from "./some";

sort

sort returns an array sorted by criteria.

export { default as SORT } from "./sort";
export { default as sort } from "./sort";

unflatten

unflatten returns an array with values unflattened into arrays of arrays.

export { default as UNFLATTEN } from "./unflatten";
export { default as unFlatten } from "./unflatten";
export { default as unflatten } from "./unflatten";

unique

unique returns the list of unique values from an array.

export { default as UNIQUE } from "./unique";
export { default as unique } from "./unique";

¶

Objects

changed

changed computes the list of keys that are different between two objects.

export { default as CHANGED } from "./changed";
export { default as changed } from "./changed";

diff

diff computes the unique left, unique right and changed properties of two objects.

export { default as DIFF } from "./diff";
export { default as diff } from "./diff";

clean

clean returns an object skipping properties with empty values.

export { default as CLEAN } from "./clean";
export { default as clean } from "./clean";

get

get returns the value of a property from an object.

export { default as GET } from "./get";
export { default as get } from "./get";

select

select returns an object with keys limited to a given set.

export { default as SELECT } from "./select";
export { default as select } from "./select";

keys

keys returns the list of properties in an object.

export { default as KEYS } from "./keys";
export { default as keys } from "./keys";

¶

Utility

address

address returns a row/column reference.

export { default as ADDRESS } from "./address";
export { default as address } from "./address";

assign

assign returns the result of merging two or more objects.

export { default as ASSIGN } from "./assign";
export { default as assign } from "./assign";

base

base returns a number into a text representation with the given radix.

export { default as BASE } from "./base";
export { default as base } from "./base";

cellindex

cellindex computes the index of a row/column in a fixed size 1 dimensional space.

export { default as CELLINDEX } from "./cellindex";
export { default as cellIndex } from "./cellindex";
export { default as cellindex } from "./cellindex";

ceiling

ceiling returns a number rounded up to a specified multiple.

export { default as CEILING } from "./ceiling";
export { default as ceiling } from "./ceiling";

column

column returns the column index from a cell index.

export { default as COLUMN } from "./column";
export { default as column } from "./column";

columnletter

column returns the column letter from a cell index.

export { default as COLUMNLETTER } from "./columnletter";
export { default as columnLetter } from "./columnletter";
export { default as columnletter } from "./columnletter";

columnnumber

columnnumber converts a column letter into a number.

export { default as COLUMNNUMBER } from "./columnnumber";
export { default as columnNumber } from "./columnnumber";
export { default as columnnumber } from "./columnnumber";

decodebase64

decodeBase64 decodes the base 64 binary into string

export { default as DECODEBASE64 } from "./decodebase64";
export { default as decodeBase64 } from "./decodebase64";
export { default as decodebase64 } from "./decodebase64";

decodejwt

decodeJWT decodes the payload from a JSON Web Token

export { default as DECODEJWT } from "./decodejwt";
export { default as decodeJWT } from "./decodejwt";
export { default as decodejwt } from "./decodejwt";

entries

entries returns returns an array of a given object’s own enumerable property [key, value] pairs.

export { default as ENTRIES } from "./entries";
export { default as entries } from "./entries";

even

even returns a number rounded up the nearest even integer.

export { default as EVEN } from "./even";
export { default as even } from "./even";

floor

floor returns a number rounded down to a specified multiple.

export { default as FLOOR } from "./floor";
export { default as floor } from "./floor";

group

group returns data group by one or more fields.

export { default as GROUP } from "./group";
export { default as group } from "./group";

guid

guid returns a new globally unique identifier (version 4).

export { default as GUID } from "./guid";
export { default as guid } from "./guid";

hash

hash returns a new globally unique identifier (version 4).

export { default as HASH } from "./hash";
export { default as hash } from "./hash";

int

int return the floor of a number.

export { default as INT } from "./int";
export { default as int } from "./int";

index2col

index2col computes the column given a cell index.

export { default as INDEX2COL } from "./index2col";
export { default as index2Col } from "./index2col";
export { default as index2col } from "./index2col";

index2row

index2row computes the row given a cell index.

export { default as INDEX2ROW } from "./index2row";
export { default as index2Row } from "./index2row";
export { default as index2row } from "./index2row";

intersect

intersect returns true if two rectangles intersect.

export { default as INTERSECT } from "./intersect";
export { default as intersect } from "./intersect";

interpolate

interpolate computes a number a percentage distance between a and b.

export { default as INTERPOLATE } from "./interpolate";
export { default as interpolate } from "./interpolate";

interpolator

interpolator creates a function that accepts a percentage distance between a and b, used by interpolate.

export { default as INTERPOLATOR } from "./interpolator";
export { default as interpolator } from "./interpolator";

n

n converts a value to a number. It supports numbers, true, false and dates.

export { default as N } from "./n";
export { default as n } from "./n";

numbers

numbers returns the numbers from an array.

export { default as NUMBERS } from "./numbers";
export { default as numbers } from "./numbers";

overlap

overlap returns true if two rectangles overlap.

export { default as OVERLAP } from "./overlap";
export { default as overlap } from "./overlap";

ref

ref returns a ref object that represents a range.

export { default as REF } from "./ref";
export { default as ref } from "./ref";

serial

serial converts a JS date into the number of days from 1/1/1900.

export { default as SERIAL } from "./serial";
export { default as serial } from "./serial";

functions.js

Formula’s Functions

Functions

Formula

LogicalRUN

Math functions

Text

Lookup and reference

Date manipulation

Aggregation

Finance