Learn about different types of formulas for Excel and Google sheets and what they do
ARRAY
Array formulas allow you to perform calculations on multiple values simultaneously within a range. They can process arrays of data and return arrays of results, making it easier to perform complex calculations or operations across multiple cells.
database
Database formulas and functions are used to work with structured data and perform operations like querying, filtering, sorting, and summarizing data. They are particularly useful for managing and manipulating large datasets efficiently.
DATE
Date formulas and functions allow you to manipulate and format dates and times. They enable you to perform calculations with dates, extract specific date components, determine time differences, and format dates according to various standards or custom requirements.
ENGINEERING
Engineering formulas and functions are designed for performing engineering-related calculations. They encompass conversions, trigonometry, logarithms, statistical analysis, and other mathematical operations specific to engineering disciplines.
FilTER
Filter formulas and functions enable you to extract specific data from a dataset based on predefined criteria. They allow you to apply filters to a range or dataset and retrieve only the rows or columns that meet the specified conditions.
FINANCIAL
Financial formulas and functions are used for financial calculations. They include interest calculations, loan payments, future value, present value, net present value (NPV), internal rate of return (IRR), and other financial metrics or analysis.
GOOGLE
The term 'Google' in this context refers to Google Sheets, a cloud-based spreadsheet software. Google Sheets offers a range of formulas and functions for data manipulation, calculations, and analysis. It provides similar functionalities to Microsoft Excel.
INFO
Info formulas and functions provide information about data. They can retrieve details about data types, formatting, cell references, and other properties. These formulas are useful for obtaining specific information or metadata about cells or ranges within a spreadsheet.
LOGICAL
Logical formulas and functions evaluate logical conditions and return logical results (TRUE or FALSE). They enable you to perform logical comparisons, logical operations (AND, OR, NOT), and build conditional expressions for decision-making or data filtering purposes.
LOOKUP
Lookup formulas and functions are used to search for specific values in a range and retrieve related information. They enable you to perform searches, find matches, and retrieve data based on specified criteria or conditions.
MATH
Math formulas and functions encompass basic arithmetic operations (addition, subtraction, multiplication, division), trigonometric functions, logarithms, exponents, rounding, and other mathematical calculations.
OPERATOR
Operator formulas and functions utilize basic mathematical operators (+, -, *, /) for arithmetic operations. They allow you to perform calculations using these operators to manipulate numerical values.
PARSER
Parser formulas and functions analyze and manipulate text or data structures. They enable you to extract specific information from text, split strings, concatenate text, replace characters or substrings, and perform other text-related manipulations.
STATISTICAL
Statistical formulas and functions are used for statistical analysis. They include measures of central tendency (mean, median, mode), dispersion (variance, standard deviation), regression analysis, hypothesis testing, and other statistical calculations.
TEXT
Text formulas and functions are designed for manipulating and formatting text strings. They allow you to concatenate text, extract substrings, convert text cases, replace characters, perform string manipulations, and format text according to specific requirements.
WEB
Web formulas and functions facilitate interactions with web-based services or retrieving data from the internet. They enable you to connect to external APIs, retrieve data from web sources, and perform operations related to web data processing or analysis.