Grid
Cell Format
Align
History
Options
Auto Select
Formulas
Math & Aggregation
expand_more
=SUM(range)
Sum of all numeric cells in range.
=SUM(A1:A10)
=AVERAGE(range)
Mean of all numeric values.
=AVERAGE(B1:B5)
=MIN(range)
Smallest value in range.
=MIN(C1:C20)
=MAX(range)
Largest value in range.
=MAX(C1:C20)
=COUNT(range)
Number of numeric cells in range.
=COUNT(A1:A10)
Logic
expand_more
=IF(test, true, false)
Returns one value if condition is true, another if false.
=IF(A1>10, "High", "Low")
Text
expand_more
=CONCAT(cell1, cell2, …)
Joins values from multiple cells into one string.
=CONCAT(A1, B1)
Date & Time
expand_more
=DATE
Current date as DD/MM/YYYY.
=DATE
=YEAR
Current year (e.g. 2025).
=YEAR
=MONTH
Full name of current month.
=MONTH
=DAY
Full name of current weekday.
=DAY
=DATEM
Day of month as a number (1–31).
=DATEM
Random
expand_more
=RANDOM(range or list)
Returns the value of a random cell from a range or comma-separated list.
=RANDOM(A1:A5)
=RN(min:max)
Random integer between two numbers.
=RN(1:100)