An assembly of functions that faithfully match their Excel equivalents in terms of functionality and errors.
This includes an assembly of other general purpose ExpressionFunction(s) from other repos. In some cases function
names have been changed to avoid clashes with excel functions (eg log aka math log vs log aka log a message).
- boolean
- color
- datetime
- engineering
- environment
- json
- net
- net-expression-function
- number
- number-trigonometry
- stat
- storage-expression-function
- string
- terminal
- tree
- tree-text
- validation
The two links below provide links to available functions in Excel and Sheets
Google Sheets and Microsoft Excel have over 500 functions.
The list below (with 280) is incomplete and constantly being updated as new functions are added. A small number are not found in Sheets or Excel and may be used to interact with features not found in those two platforms.
- abs
- acos
- address
- and
- asin
- atan
- average
- averageIf
- badge
- base
- bin2dec
- bin2hex
- bin2oct
- bitand
- bitor
- bitxor
- border
- ceil
- cell
- cellCurrency
- cellDateTimeSymbols
- cellDecimalNumberSymbols
- cellFormattedValue
- cellFormatter
- cellFormula
- cellLocale
- cellParser
- cellStyle
- cellValidator
- cellValue
- cellValueType
- char
- choose
- clean
- code
- color
- column
- columns
- concat
- cos
- cosh
- count
- countA - count when non null
- countBlank
- countIf
- createSpreadsheetMetadata
- currency
- currencyCode
- currencyValue
- date
- day
- days
- debug
- dec2bin
- dec2hex
- dec2oct
- decimal
- degrees
- deleteSpreadsheetMetadata
- deleteStorage
- delta
- dollar
- e
- emailAddress
- error
- eval
- even
- exact
- exit
- exp
- false
- fileStorage
- find
- fixed
- flag
- floor
- formatValue
- formulatext
- getAlpha
- getBlue
- getCharset
- getCurrency
- getCurrentWorkingDirectory
- getDateTimeSymbols
- getDecimalNumberSymbols
- getEnv
- getFormatter
- getFormatValue
- getFormulaText
- getGreen
- getHomeDirectory
- getHost
- getIndentation
- getLineEnding
- getLocale
- getParser
- getRed
- getSpreadsheetMetadataValue
- getStyle
- getTextNode
- getTimeOffset
- getUser
- getValidator
- getValue
- hex2bin
- hex2dec
- hex2oct
- hour
- hyperlink
- if
- ifs
- image
- indirect
- int
- invertColor
- isBlank
- isDate
- isErr
- isError
- isEven
- isFormula
- isLogical
- isNa
- isNonText
- isNull
- isNumber
- isOdd
- isoWeeknum
- isRef
- isText
- json
- jsonPointer
- jsonPointerEval
- jsonSelector
- jsonSelectorEval
- jsonText
- lambda
- left
- len
- let
- list
- listNonNull
- listStorage
- ln
- loadSpreadsheetMetadata
- locale
- localeLanguageTag
- log
- log10
- loggingLevel
- logError
- logInfo
- logMessage
- logWarn
- lower
- margin
- max
- maxIf
- mergeStyle
- memoryStorage
- mid
- min
- minIf
- minute
- mixColor
- mod
- month
- mount
- mountPoints
- nextEmptyColumn
- nextEmptyRow
- not
- now
- null
- numberValue
- oct2bin
- oct2dec
- oct2hex
- odd
- offset
- or
- padding
- pi
- printEnv
- println
- product
- proper
- quotient
- radians
- random
- randomBetween
- readLine
- readStorage
- readStorageText
- removeEnv
- removeSpreadsheetMetadataValue
- replace
- rept
- right
- roman
- round
- roundDown
- roundUp
- row
- rows
- saveSpreadsheetMetadata
- script
- search
- second
- setAlpha
- setBlue
- setCharset
- setCurrency
- setCurrentWorkingDirectory
- setEnv
- setGreen
- setHomeDirectory
- setHost
- setIndentation
- setLineEnding
- setLocale
- setRed
- setSpreadsheetMetadataValue
- setStyle
- setText
- setTimeOffset
- shell
- sign
- sin
- sinh
- spreadsheetUrl
- sqrt
- style
- styledText
- styleGet
- styleRemove
- styleRemoveIf
- styleReplaceIf
- styleSet
- substitute
- sum
- sumIf
- switch
- t
- tan
- tanh
- template
- text
- textJoin
- textMatch
- time
- today
- toGray
- toHslColor
- toHsvColor
- toRgbColor
- toRgbHexString
- toWebColorName
- treeText
- trim
- true
- trunc
- type
- unichar
- unicode
- unmount
- upper
- url
- validationChoiceList
- validationError
- validationErrorIf
- validationValue
- value
- weekday)
- weeknum
- writeStorage
- writeStorageText
- xor
- year
Many more functions are outstanding and remain TODO.