=AVERAGE()
=MEDIAN()
=MIN()
=MAX()
=COUNT()
count tallies the number of cells in a range that contain values
=COUNTBLANK()
tallies the number of blank cells in a range
=COUNTA()
tallies the number of cells in a range that are not empty.
=ABS(number)
displays the absolute (i.e. positive) value of a number
=FREQUENCY(data_array, bins_array)
counts how often values appear in a given range
=INT(number)
rounds a value number down to the nearest whole number
=MODE.SNGL(number1,[number2],...)
displays the most frequently occurring value in a list
=PI()
Returns the value of pi that is accurate up to 15 digits
=PRODUCT(number1, [number2],..)
Multiplies all values within the argument list
=RANDBETWEEN(bottom,top)
Generates a random number between two numbers you specify
=RANK.AVG(number,ref,[order])
Identifies a values rank within a list of values; returns an average rank for identical values.
Returns the value of pi that is accurate up to 15 digits
=PRODUCT(number1, [number2],..)
Multiplies all values within the argument list
=RANDBETWEEN(bottom,top)
Generates a random number between two numbers you specify
=RANK.AVG(number,ref,[order])
Identifies a values rank within a list of values; returns an average rank for identical values.
=RANK.EQ(number, ref,[order])
Identifies a values rank within a list of values; the top rank is identified for all identical values.
=ROUND(number,num_digits)
Rounds a value to a specific number of digits. Rounds numbers of 5 and greater up and those less than 5 down.
=SUMPRODUCT(array1,[array2],[array3],...)
Finds the result of multiplying values in one range by the related values in another column and then adding those products.
=TRIMMEAN(array,percent)
Returns the arithmetic average of the internal values in a range by excluding a specified percentage of values at the upper and lower values in the data set. This function helps reduce the effect outliers (i.e. extreme values) have on the arithmetic mean
=TRUNC(number,[num_digits])
Returns the integer equivalent of a number by truncating or removing the decimal or fractional part of the number. For example,=TRUNC(45.5) returns 45.
=IF(logical_test,value_if_true,value_if_false)
=VLOOKUP(Lookup_value,table_array,col_index_number,[range_lookup])
=SUMIF(range,criteria,sum_range)
=AVERAGEIF(range, criteria, average_range)
=COUNTIF(range,criteria)
=SUMIFS(sum_range, critera_range1,criteria1,criteria_range2,criteria2...)
=AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria...)
=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2...)
=MATCH(lookup_value,lookup_array,[match_type])
=INDEX(array,row_num,[column_num])
Identifies a values rank within a list of values; the top rank is identified for all identical values.
=ROUND(number,num_digits)
Rounds a value to a specific number of digits. Rounds numbers of 5 and greater up and those less than 5 down.
=SUMPRODUCT(array1,[array2],[array3],...)
Finds the result of multiplying values in one range by the related values in another column and then adding those products.
=TRIMMEAN(array,percent)
Returns the arithmetic average of the internal values in a range by excluding a specified percentage of values at the upper and lower values in the data set. This function helps reduce the effect outliers (i.e. extreme values) have on the arithmetic mean
=TRUNC(number,[num_digits])
Returns the integer equivalent of a number by truncating or removing the decimal or fractional part of the number. For example,=TRUNC(45.5) returns 45.
=IF(logical_test,value_if_true,value_if_false)
=VLOOKUP(Lookup_value,table_array,col_index_number,[range_lookup])
=SUMIF(range,criteria,sum_range)
=AVERAGEIF(range, criteria, average_range)
=COUNTIF(range,criteria)
=SUMIFS(sum_range, critera_range1,criteria1,criteria_range2,criteria2...)
=AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria...)
=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2...)
=MATCH(lookup_value,lookup_array,[match_type])
=INDEX(array,row_num,[column_num])
