Fuctions to use
- Sum
- Average
- Median
- Even (get a list of even numbers of an array)
- Someeven (get true/false if some of the elements are even)
- Everyeven (get true/false if every element is even)
- Firsttwo (first two elements of an array)
- Lasttwo (last two elements of an array)
- Has2 (if an array has number 2)
- Increment (increase every element by 1)
- Random (get a random number between first 2 elements)
- Range (get a range starting from first ending with second element)
- Nodupes (get a list with unique elements)
Example:
Put some numbers into cells A1 and A2
Choose another cell, for example A3 -> to use Sum you need to type -> =sum(A1:A2)