PARKING LOT ITEMS
FUNCTION LIST (A-Z) last update: 2/25/22
AND - returns TRUE if all arguments are TRUE
AVERAGE - returns the average of its arguments
AVERAGEIF - returns the average of all the cells in a range that meet a given criteria
AVERAGEIFS - returns the average of all cells that meet multiple criteria
COUNT - counts how many numbers are in the list of arguments
COUNTA - counts how many values are in the list of arguments
COUNTBLANK - counts the number of blank cells within a range
COUNTIF - counts the number of cells within a range that meet the given criteria
COUNTIFS - counts the number of cells within a range that meet multiple criteria
DATE - returns the serial number of a particular date
DATEDIF - calculates the number of days, months, or years between two dates
DATEVALUE - converts a date in the form of text to a serial number
DAY - converts a serial number to a day of the month
DAYS - returns the number of days between two dates
FALSE - returns the logical value FALSE
FV - returns the future value of an investment
IF - specifies a logical test to perform
IFERROR - returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula
IFNA - returns the value you specify if the expression resolves to #N/A; otherwise returns the result of the expression
IFS - checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
ISBLANK - returns TRUE if the value is blank
ISERR - returns TRUE if the value is any error value except #N/A
ISERROR - returns TRUE if the value is any error value
LEFT, LEFTB - returns the leftmost characters from a text value
LOOKUP - looks up values in a vector or array
LOWER - converts text to lowercase
MAX - returns the maximum values in a list of arguments
MAXIFS - returns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN - returns the median of the given numbers
MIN - returns the minimum value in a list of arguments
MINIFS - returns the minimum value among cells specified by a given set of conditions or criteria
MONTH - converts a serial number to a month
NETWORKDAYS - returns the number of whole workdays between two dates
NOW - returns the serial number of the current date and time
RAND - returns a random number between 0 and 1
RIGHT, RIGHTB - returns the rightmost characters from a text value
ROUND - rounds a number to a specified number of digits
ROUNDDOWN - rounds a number down, toward zero
ROUNDUP - rounds a number up, away from zero
SECOND - converts a serial number to a second
SUM - adds its arguments together
SUMIF - adds the cells specified by a given range
SUMIFS - adds the cells in a range that meet multiple criteria
TEXT - formats a number and converts it to text
TIME - returns the serial number of a particular time
TODAY - returns the serial number of today's date
TRIM - removes spaces from text
TRUE - returns the logical value TRUE
UPPER - converts text to uppercase
VALUE - converts a text argument to a number
VLOOKUP - looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAY - converts a serial number to a day of the week
WEEKNUM - converts a serial number representing where the week falls numerically with a year
YEAR - converts a serial number to a year
AVERAGE - returns the average of its arguments
AVERAGEIF - returns the average of all the cells in a range that meet a given criteria
AVERAGEIFS - returns the average of all cells that meet multiple criteria
COUNT - counts how many numbers are in the list of arguments
COUNTA - counts how many values are in the list of arguments
COUNTBLANK - counts the number of blank cells within a range
COUNTIF - counts the number of cells within a range that meet the given criteria
COUNTIFS - counts the number of cells within a range that meet multiple criteria
DATE - returns the serial number of a particular date
DATEDIF - calculates the number of days, months, or years between two dates
DATEVALUE - converts a date in the form of text to a serial number
DAY - converts a serial number to a day of the month
DAYS - returns the number of days between two dates
FALSE - returns the logical value FALSE
FV - returns the future value of an investment
IF - specifies a logical test to perform
IFERROR - returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula
IFNA - returns the value you specify if the expression resolves to #N/A; otherwise returns the result of the expression
IFS - checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
ISBLANK - returns TRUE if the value is blank
ISERR - returns TRUE if the value is any error value except #N/A
ISERROR - returns TRUE if the value is any error value
LEFT, LEFTB - returns the leftmost characters from a text value
LOOKUP - looks up values in a vector or array
LOWER - converts text to lowercase
MAX - returns the maximum values in a list of arguments
MAXIFS - returns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN - returns the median of the given numbers
MIN - returns the minimum value in a list of arguments
MINIFS - returns the minimum value among cells specified by a given set of conditions or criteria
MONTH - converts a serial number to a month
NETWORKDAYS - returns the number of whole workdays between two dates
NOW - returns the serial number of the current date and time
RAND - returns a random number between 0 and 1
RIGHT, RIGHTB - returns the rightmost characters from a text value
ROUND - rounds a number to a specified number of digits
ROUNDDOWN - rounds a number down, toward zero
ROUNDUP - rounds a number up, away from zero
SECOND - converts a serial number to a second
SUM - adds its arguments together
SUMIF - adds the cells specified by a given range
SUMIFS - adds the cells in a range that meet multiple criteria
TEXT - formats a number and converts it to text
TIME - returns the serial number of a particular time
TODAY - returns the serial number of today's date
TRIM - removes spaces from text
TRUE - returns the logical value TRUE
UPPER - converts text to uppercase
VALUE - converts a text argument to a number
VLOOKUP - looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAY - converts a serial number to a day of the week
WEEKNUM - converts a serial number representing where the week falls numerically with a year
YEAR - converts a serial number to a year