Function Syntax Description

SUM SUM(number1, [number2], ...) Adds numbers

AVERAGE AVERAGE(number1, [number2], ...) Calculates average
COUNT COUNT(value1, [value2], ...) Counts numeric values
MAX MAX(number1, [number2], ...) Returns largest number
MIN MIN(number1, [number2], ...) Returns smallest number
IF IF(logical_test, value_if_true, value_if_false) Logical test with true/false values
AND AND(logical1, [logical2], ...) Returns TRUE if all conditions are true
OR OR(logical1, [logical2], ...) Returns TRUE if any condition is true
NOT NOT(logical) Reverses a logical value
ROUND ROUND(number, num_digits) Rounds to specific digits
TODAY TODAY() Returns current date
NOW NOW() Returns current date and time
CONCATENATE CONCATENATE(text1, [text2], ...) Joins multiple text strings
LEFT LEFT(text, [num_chars]) Extracts leftmost characters
RIGHT RIGHT(text, [num_chars]) Extracts rightmost characters
MID MID(TEXT, start_num, num_chars) Extracts text from middle
LEN LEN(TEXT) Returns length of text
SUBSTITUTE SUBSTITUTE(text, old_text, new_text, [instance_num]) Replaces text within a string
TRIM TRIM(TEXT) Removes extra spaces
PROPER PROPER(TEXT) Capitalizes each word
UPPER UPPER(TEXT) Converts text to uppercase
DATE DATE(YEAR, MONTH, DAY) Creates a date
TIME TIME(HOUR, MINUTE, SECOND) Creates a time value
VLOOKUP VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Searches vertically in a table
HLOOKUP HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Searches horizontally in a table
INDEX INDEX(array, row_num, [column_num]) Returns value at a specific row/column
MATCH MATCH(lookup_value, lookup_array, [match_type]) Returns position of a value
Function Syntax Description
CHOOSE CHOOSE(index_num, value1, [value2], ...) Chooses from a list
ROUNDUP ROUNDUP(number, num_digits) Rounds number up
ROUNDDOWN ROUNDDOWN(number, num_digits) Rounds number down
RAND RAND() Returns random number between 0 and 1
RANK RANK(number, ref, [order]) Ranks a number within a list
COUNTIF COUNTIF(range, criteria) Counts cells that meet condition
SUMIF SUMIF(range, criteria, [sum_range]) Adds values based on condition
AVERAGEIF AVERAGEIF(range, criteria, [average_range]) Averages values based on condition
COUNTIFS COUNTIFS(criteria_range1, criteria1, ...) Counts with multiple criteria
SUMIFS SUMIFS(sum_range, criteria_range1, criteria1, …) Adds with multiple conditions
AVERAGEIFS AVERAGEIFS(average_range, criteria_range1, criteria1, …) Averages with multiple conditions
IFERROR IFERROR(VALUE, value_if_error) Handles errors with default value
TEXT TEXT(VALUE, format_text) Formats numbers or dates as text
MIDB MIDB(TEXT, start_num, num_bytes) MID for double-byte text (DBCS)
LENB LENB(TEXT) Length for double-byte text (DBCS)
SUBSTITUTEB SUBSTITUTEB(text, old_text, new_text, [instance_num]) SUBSTITUTE for DBCS languages
TRIMB TRIMB(TEXT) TRIM for DBCS text
PROPERB PROPERB(TEXT) PROPER for DBCS
LOWERB LOWERB(TEXT) LOWER for DBCS
UPPERB UPPERB(TEXT) UPPER for DBCS
DATEVALUE DATEVALUE(date_text) Converts text to a date
TIMEVALUE TIMEVALUE(time_text) Converts text to time
YEAR YEAR(serial_number) Extracts year from date
MONTH MONTH(serial_number) Extracts month from date
DAY DAY(serial_number) Extracts day from date
HOUR HOUR(serial_number) Gets hour from time
MINUTE MINUTE(serial_number) Gets minutes from time
Function Syntax Description
SECOND SECOND(serial_number) Gets seconds from time
NETWORKDAYS NETWORKDAYS(start_date, end_date, [holidays]) Working days between two dates
WORKDAY WORKDAY(start_date, days, [holidays]) Returns future/past workday
EOMONTH EOMONTH(start_date, months) Last day of the month
DATEDIF DATEDIF(start_date, end_date, unit) Calculates difference between dates
TIME TIME(HOUR, MINUTE, SECOND) Creates time from hours, minutes, seconds
ISTEXT ISTEXT(VALUE) Checks if value is text
ISBLANK ISBLANK(VALUE) Checks if cell is empty
IF IF(logical_test, value_if_true, value_if_false) Logical decision
AND AND(logical1, [logical2], ...) TRUE if all conditions are TRUE
OR OR(logical1, [logical2], ...) TRUE if any condition is TRUE
NOT NOT(logical) Reverses logic (TRUE→FALSE)
SUMPRODUCT SUMPRODUCT(array1, [array2], …) Multiplies and adds arrays
CONCATENATE CONCATENATE(text1, [text2], ...) Joins text strings
TEXTJOIN TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Joins text with delimiter
MAXIFS MAXIFS(max_range, criteria_range1, criteria1, …) Max value with conditions
MINIFS MINIFS(min_range, criteria_range1, criteria1, …) Min value with conditions
COUNTIFS COUNTIFS(criteria_range1, criteria1, ...) Count cells with multiple conditions
SUMIFS SUMIFS(sum_range, criteria_range1, criteria1, …) Sum with multiple conditions
AVERAGEIFS AVERAGEIFS(average_range, criteria_range1, criteria1, …) Average with multiple conditions
IFERROR IFERROR(VALUE, value_if_error) Returns value or fallback if error
TEXT TEXT(VALUE, format_text) Formats a number/text
WEEKNUM WEEKNUM(serial_number, [return_type]) Week number of the year
DAYS DAYS(end_date, start_date) Number of days between dates
ISNUMBER ISNUMBER(VALUE) Checks if value is a number
DATEDIF DATEDIF(start_date, end_date, unit) Returns difference between dates