Please enable JavaScript.
Coggle requires JavaScript to display documents.
Spreadsheets, Statistics - Coggle Diagram
Spreadsheets
Checkers
ISNUMBER()
ISTEXT()
ISDATE
ISLOGICAL()
ISURL()
ISFORMULA()
ISBLANK()
ISERROR
ISERR
Data Types
Numeric
AVERAGE
MEDIAN
SUM
MULTIPLY
SUMPRODUCT
Formatter
TO_DOLLARS
TO_PERCENT
Converter
N
CONVERT
RANK
Transformer
LN
LOG
LOG10
EXP
ROUND
CEILING
FLOOR
Text
UPPER
LOWER
PROPER
LEN
SEARCH
CONCATENATE
TRIM
SUBSTITUTE
LEFT
RIGHT
DateTime
TODAY
NOW
YEAR
MONTH
WEEKDAY
HOUR
MINUTE
SECOND
DATEDIF
DATEVALUE
Logical
IF
IFS
AND
SWITCH
OR
NOT
Cell
ROW
COLUMN
ADDRESS
INDIRECT
Lookup
VLOOKUP
HLOOKUP
OFFSET
INDEX
Random
RAND
RANDBETWEEN
Distribution Generator
NOMRINV
LOGINV
BETAINV
Aggregators
Count
COUNT
COUNTIF
COUNTBLANK
COUNTIFS
COUNTUNIQUE
Sum
SUMIF
SUMIFS
SUMPRODUCT
Average
AVERAGE
AVERAGEIF
Operations
across data types
SORT
FILTER
UNIQUE
Statistics
Tests
T.TEST
Z.TEST
CHITEST
MEDIAN
MODE
VAR / VARP
STDEV / STDEVP
QUARTILE
STANDARDIZE
SKEW
KURT
LINEST
CORREL
SLOPE
INTERCEPT
AVERAGE