Generates a random number 3 and 9 (gives a
RAND
decimal)
RAND
Generates a random number between
=randbetween(bottom value, Top value) bottom and top parameter (Without a RANDBETWEEN
decimal)
The Biggest number MAX
The Smallest number MIN
Returns the biggest number in a certain
position (2nd biggest)
LARGE Max, Min, Large and Small Functions
Returns the smallest number in a certain
SMALL
position (3rd smallest)
It is a function that totals a specified function
=subtotal(1 (average), E1:E6)
of a certain amount of numbers SUBTOTAL
Counts the number of cells that contain
COUNT
number
Counts the numberof cells that are not
COUNTA
empty
COUNT
counts the number of empty cells in the
COUNTBLANK
range
Counts the range of cells that meets a
(B2:E5, "<15") COUNTIF
certain criteria
RAND
decimal)
RAND
Generates a random number between
=randbetween(bottom value, Top value) bottom and top parameter (Without a RANDBETWEEN
decimal)
The Biggest number MAX
The Smallest number MIN
Returns the biggest number in a certain
position (2nd biggest)
LARGE Max, Min, Large and Small Functions
Returns the smallest number in a certain
SMALL
position (3rd smallest)
It is a function that totals a specified function
=subtotal(1 (average), E1:E6)
of a certain amount of numbers SUBTOTAL
Counts the number of cells that contain
COUNT
number
Counts the numberof cells that are not
COUNTA
empty
COUNT
counts the number of empty cells in the
COUNTBLANK
range
Counts the range of cells that meets a
(B2:E5, "<15") COUNTIF
certain criteria
