Please enable JavaScript.
Coggle requires JavaScript to display documents.
Spreadsheet functions (Mathematical (=SUM(A1:A3)
Returns the sum of a…
Spreadsheet functions
Mathematical
-
=SUMIF(A1:A3,">20")
Conditional sum across a range.
-
-
-
-
-
=RANK(1, A1:A3, [1])
(value, data, [is_ascending])
Logical
=IF(A1 = ">10", "PASS", "FAIL")
Returns one value if a logical expression is 'TRUE' and another if it is 'FALSE.'
=AND(A2=2, A3=3)
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
=NOT(TRUE)
Returns the opposite of a logical value – 'NOT(TRUE)' returns 'FALSE'; 'NOT(FALSE)' returns 'TRUE'.
=OR(A2=2, A3=3)
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
-
=VLOOKUP(100, A1:B3, 2, FALSE)
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
Statistical
-
-
=AVERAGE(A1:A3)
Returns the numerical average value in a dataset, ignoring text.
=COUNT(A1:A3, B1:B3)
Return the number of numeric values in a dataset.
=COUNTA(A1:A3, B1:B3)
Returns the number of values in a dataset.
=COUNTIF(A1:A3, ">20")
Returns a conditional count across a range.
= equal to
= greater than or equal to
greater than
<= less than or equal to
< less than
<> not equal to
-