sheets.wiki

Home

❯

docs

Folder: docs

533 items under this folder.

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

GitHub
Discord Community
Subreddit

Explorer

Folder: docs