sheets.wiki
Search
Search
Dark mode
Light mode
Explorer
archive
Classic LAMBDA UDTs
blog
An Alternative Approach to Using AND-OR
Asking Questions
Color and Other Formatting Should Follow Data, Not Transmit It
Creating sheets.wiki
Emoji Modifiers
Last Click Using Timestamps
Levenshtein Distance
On Computer Science and Spreadsheets
Practice
Taming Spreadsheet Data Structure For Success
Traditional vs. Array-Based Approaches for Multi-Dimensional Data in Spreadsheets
collections
Discord Netiquette
Functions
Understanding Theory
docs
ABS
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
ADD
ADDRESS
AMORLINC
AND
ARABIC
Array
ARRAY_CONSTRAIN
ARRAYFORMULA
ASC
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGE.WEIGHTED
AVERAGEA
AVERAGEIF
AVERAGEIFS
Bad Practice
BASE
BETA.DIST
BETA.INV
BETADIST
BETAINV
BIN2DEC
BIN2HEX
BIN2OCT
BINOM.DIST
BINOM.INV
BINOMDIST
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
Boolean
BYCOL
BYROW
Calculation Limits
CEILING
CEILING.MATH
CEILING.PRECISE
CELL
CHAR
CHIDIST
CHIINV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CHOOSE
CHOOSECOLS
CHOOSEROWS
CLEAN
CODE
COLUMN
COLUMNS
COMBIN
COMBINA
COMPLEX
Compressing data for exporting
CONCAT
CONCATENATE
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
CONVERT
CORREL
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COUNTUNIQUE
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
COVAR
COVARIANCE.P
COVARIANCE.S
CRITBINOM
CSC
CSCH
CUMIPMT
CUMPRINC
Data type
DATE
DATEDIF
Datetime
DATEVALUE
DAVERAGE
DAY
DAYS
DAYS360
DB
DCOUNT
DCOUNTA
DDB
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
DEGREES
DELTA
DETECTLANGUAGE
DEVSQ
DGET
DISC
DIVIDE
DMAX
DMIN
Documenting formulas
DOLLAR
DOLLARDE
DOLLARFR
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DURATION
DVAR
DVARP
EDATE
EFFECT
ENCODEURL
EOMONTH
EPOCHTODATE
EQ
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
EVEN
EXACT
EXP
EXPON.DIST
EXPONDIST
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FACT
FACTDOUBLE
FALSE
FDIST
FILTER
FIND
FINDB
FINV
FISHER
FISHERINV
FIXED
FLATTEN
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FORECAST
FORECAST.LINEAR
FORMULATEXT
FREQUENCY
FTEST
FV
FVSCHEDULE
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
GCD
GEOMEAN
GESTEP
GETPIVOTDATA
GOOGLEFINANCE
GOOGLETRANSLATE
GROWTH
GT
GTE
HARMEAN
HEX2BIN
HEX2DEC
HEX2OCT
HLOOKUP
HOUR
HSTACK
HYPERLINK
HYPGEOM.DIST
HYPGEOMDIST
IF
IFERROR
IFNA
IFS
IMABS
IMAGE
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCOTH
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG
IMLOG2
IMLOG10
IMPORTDATA
IMPORTFEED
IMPORTHTML
IMPORTRANGE
IMPORTXML
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
IMTANH
INDEX
INDIRECT
INT
INTERCEPT
INTRATE
IPMT
IRR
ISBETWEEN
ISBLANK
ISDATE
ISEMAIL
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
ISURL
JOIN
KURT
LAMBDA
LAMBDA data structures
LAMBDA recursion
LAMBDA refactoring
LAMBDA UDT
LAMBDA update suppression
LARGE
LCM
LEFT
LEFTB
LEN
LENB
LET
LINEST
LN
LOG
LOG10
LOGEST
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOOKUP
LOWER
LT
LTE
MAKEARRAY
MAP
MARGINOFERROR
MATCH
MAX
MAXA
MAXIFS
MDETERM
MDURATION
MEDIAN
MID
MIDB
MIN
MINA
MINIFS
MINUS
MINUTE
MINVERSE
MIRR
MMULT
MOD
MODE
MODE.MULT
MODE.SNGL
MONTH
MROUND
MULTINOMIAL
MULTIPLY
MUNIT
N
NA
NE
NEGBINOM.DIST
NEGBINOMDIST
NETWORKDAYS
NETWORKDAYS.INTL
NOMINAL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NORMDIST
NORMINV
NORMSDIST
NORMSINV
NOT
NOW
NPER
NPV
OCT2BIN
OCT2DEC
OCT2HEX
ODD
OFFSET
Operator
OR
PDURATION
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
PI
PMT
POISSON
POISSON.DIST
POW
POWER
PPMT
PRICE
PRICEDISC
PRICEMAT
PROB
PRODUCT
PROPER
PV
QUARTILE
QUARTILE.EXC
QUARTILE.INC
QUERY
QUERY arithmetic
QUERY smush
QUOTIENT
RADIANS
RAND
RANDARRAY
RANDBETWEEN
RANK
RANK.AVG
RANK.EQ
RATE
RECEIVED
REDUCE
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
RRI
RSQ
SCAN
SEARCH
SEARCHB
SEC
SECH
SECOND
SEQUENCE
SERIESSUM
SIGN
SIN
SINH
SKEW
SKEW.P
SLN
SLOPE
SMALL
SORT
SORTN
SPARKLINE
SPLIT
SQRT
SQRTPI
STANDARDIZE
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVP
STDEVPA
STEYX
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SWITCH
SYD
T
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
Table
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
Term
TEXT
TEXTJOIN
TIME
TIMEVALUE
TINV
TO_DATE
TO_DOLLARS
TO_PERCENT
TO_PURE_NUMBER
TO_TEXT
TOCOL
TODAY
TOROW
TRANSPOSE
TREND
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
TYPE
Type coercion
UMINUS
UNARY_PERCENT
UNICHAR
UNICODE
UNIQUE
Unstable
UPLUS
UPPER
VALUE
VAR
VAR.P
VAR.S
VARA
VARP
VARPA
VDB
VLOOKUP
VSTACK
WEEKDAY
WEEKNUM
WEIBULL
WEIBULL.DIST
WORKDAY
WORKDAY.INTL
WRAPCOLS
WRAPROWS
XIRR
XLOOKUP
XNPV
XOR
YEAR
YEARFRAC
YIELD
YIELDDISC
YIELDMAT
Z.TEST
Zero element
ZTEST
misc
Contributing
Deprecation
Navigating sheets.wiki
Roadmap
Sheets subreddit
Spreadsheets Discord Community
Style Guide
Unofficial terminology
people
Astral
Matt King
project
anduin
ASSOC
ATTRIBUTES
CHMAP
CHVEC
Container
HASH
Express.gs
FLOOKUP
Google Sheets Package Registry
Sheets Package Installer
STRUCTFIX
Tag: anduin
7 items with this tag.
Jun 22, 2025
anduin
anduin
Jun 22, 2025
ASSOC
anduin
Jun 22, 2025
ATTRIBUTES
anduin
Jun 22, 2025
CHMAP
anduin
Jun 22, 2025
CHVEC
anduin
Jun 22, 2025
Container
anduin
Jun 22, 2025
HASH
anduin