Google Sheets function list

Fri-Dec-2023
14

Google Sheets offers a vast library of functions, making it a powerful tool for data analysis and manipulation. Here’s a breakdown of the function list categorized by their main purpose:

Basic Functions:

  • SUM: Adds up the values in a range of cells.
  • AVERAGE: Calculates the average of the values in a range of cells.
  • COUNT: Counts the number of cells in a range that contain data.
  • MIN and MAX: Finds the smallest and largest values in a range of cells.
  • IF: Performs a conditional calculation based on a specified condition.

Text Functions:

  • CONCATENATE: Combines the text from multiple cells into a single cell.
  • LEFT, RIGHT, and MID: Extracts specific characters from a text string.
  • UPPER and LOWER: Converts text to uppercase and lowercase, respectively.
  • LEN: Returns the length of a text string.
  • FIND and SEARCH: Locate specific characters or text within a string.

Date and Time Functions:

  • TODAY: Returns the current date.
  • NOW: Returns the current date and time.
  • YEAR, MONTH, and DAY: Extracts specific components from a date.
  • DATE: Creates a date value from separate year, month, and day components.
  • DATEDIF: Calculates the difference between two dates in years, months, or days.

Financial Functions:

  • PMT: Calculates the periodic payment for a loan.
  • FV: Calculates the future value of an investment.
  • PV: Calculates the present value of an investment.
  • RATE: Calculates the interest rate of a loan.
  • IRR: Calculates the internal rate of return for an investment.

Statistical Functions:

  • STDEV: Calculates the standard deviation of a range of cells.
  • VAR: Calculates the variance of a range of cells.
  • COUNTIF: Counts the number of cells meeting a specific criteria.
  • AVERAGEIF: Calculates the average of cells meeting a specific criteria.
  • CORREL: Calculates the correlation coefficient between two ranges of cells.

Lookup and Reference Functions:

  • VLOOKUP and HLOOKUP: Lookup values in a table based on specific criteria.
  • INDEX and MATCH: Find the position of a specific value within a range of cells.
  • OFFSET: Extracts a specific range of cells from a larger table.
  • INDIRECT: References a cell based on the content of another cell.

Logical Functions:

  • AND, OR, and NOT: Combine logical operators for conditional calculations.
  • IFERROR: Returns a specified value if there is an error in a formula.
  • ISBLANK and ISNUMBER: Check if a cell is blank or contains a number, respectively.

This is just a brief overview of some common Google Sheets functions. The complete list is extensive and caters to various data manipulation tasks.

Here are some additional resources to explore the full function list:

Remember, you can access the complete list of functions directly within Google Sheets. Simply click on the “Functions” menu in the toolbar and explore the various categories.

Feel free to ask me about any specific function or if you need help finding the right one for your task! I’m here to assist you with navigating the world of Google Sheets functions.