IF =IF(logical_test, [value_if_true], [value_if_false]) Checks whether a condition is met, and returns one value if TRUE and another value if FALSE AND =AND(logical1, [logical2], …) Checks whether all arguments are …

TRIM =TRIM(text) Removes all space from a text string except for single spaces between words CONCATENATE =CONCATENATE(text1, [text2], …) Joins several text strings into one text string LEN =LEN(text) Returns …

SUBTOTAL =SUBTOTAL(function_num, ref1, [ref2], …) Returns a subtotal in a list or database SUBTOTAL

ROUND =ROUND(number, num_digits) Rounds the number to a specified number of digits ROUNDUP =ROUNDUP(number, num_digits) Rounds a number up, away from zero ROUNDDOWN =ROUNDDOWN(number, num_digits) Rounds a number down, toward …

EOMONTH =EOMONTH(start_date, months) Returns the serial number of the last day of the month before or after a specified number of months and start of month DAY =DAY(serial_number) Returns the …

DAYS =DAYS(end_date, start_date) Returns the number of days between two dates NETWORKDAYS =NETWORKDAYS(start_date, end_date, [holidays]) Returns the number of whole workdays between two dates NOW =NOW() Returns the current date …

COUNT =COUNT(value1, [value2], …) Counts the number of cells in a range that contains numbers COUNTIF =COUNTIF(range, criteria) Counts the number of cells within a range that meet the given …

SUM =SUM(number1, [number2], …) Adds all the numbers in a range of cells SUMIF =SUMIF(range, criteria, [sum_range]) Adds the cells specified by a given condition or criteria SUMIFS =SUMIFS(sum_range, criteria_range1, …