~/data/spreadsheet
FUNCTIONS_AVAILABLE
SUM
Sum of values
AVERAGE
Mean average
MEDIAN
Middle value
EVEN
Filter even numbers
RANGE
Create number range
NODUPES
Remove duplicates
INCREMENT
Add 1 to values
FIRSTTWO
First two values
LASTTWO
Last two values
SOMEEVEN
Check for any even
EVERYEVEN
Check if all even
HAS2
Check for number 2
RANDOM
Generate random number
CELL_REFERENCE
=A1+B2
Basic arithmetic
=SUM(A1:A10)
Range sum
=AVERAGE(A1,B2,C3)
Multiple cells
=MEDIAN(A1:A10)
Find middle value
=EVEN(A1:A10)
Filter even numbers
=NODUPES(A1:A10)
Remove duplicates
=RANGE(1,10)
Create number sequence
=INCREMENT(A1:A5)
Add 1 to each value
=FIRSTTWO(A1:A10)
Get first 2 values
=LASTTWO(A1:A10)
Get last 2 values
=SOMEEVEN(A1:A10)
Check if any even numbers
=HAS2(A1:A10)
Check if contains number 2