Here you will find a comprehensive guide to mastering Excel functions, focusing on 100+ essential functions that are commonly used in the workplace. Each Excel function will include clear and detailed explanations along with real-world examples to help readers understand how to apply them in various situations.
Whether you are a beginner or an advanced Excel user, this Excel functions guide will provide valuable information that will help you work more efficiently and effectively in Excel
Contents
Text Functions
| Excel Functions | Description |
| LEFT Function | The LEFT function in Microsoft Excel is a text function that allows you to extract a specified number of characters from the beginning of a text string which you select. Syntax for the LEFT function is =LEFT(text,[num_chars]) |
| RIGHT Function | The RIGHT function in Microsoft Excel is a text function that allows you to extract a specified number of characters from the end of a text string which you select. Syntax for the RIGHT function is =RIGHT(text, [num_chars]) |
| MID Function | The MID Excel function in Excel is a text function that allows you to extract a specified number of characters from a text string starting at a specified position. The syntax for the MID function is =MID(text, start_num, num_chars) |
| LEN Function | The LEN function in Microsoft Excel is a text function that returns the number of characters in a text string. Syntax for the LEN function is =LEN(text) |
| UPPER Function | The UPPER function in Microsoft Excel is a text function that converts a text string to uppercase. Syntax for the UPPER function is =UPPER(text) |
| LOWER Function | The LOWER function in Microsoft Excel is a text function that converts a text string to lowercase. Syntax for the LOWER function is =LOWER(text) |
| PROPER Function | The PROPER function in Microsoft Excel is a text function that capitalizes the first letter of each word in a text string and converts all other letters to lowercase. Syntax for the PROPER function is =PROPER(text) |
| TRIM Function | The TRIM function in Microsoft Excel is a text function that removes leading and trailing spaces from a text string. Syntax for the TRIM function is =TRIM(text) |
| SUBSTITUTE Function | The SUBSTITUTE function in Microsoft Excel is a text function which replaces a specific text or a character in a text string with another text or character. Syntax for the SUBSTITUTE function is =SUBSTITUTE(text, old_text, new_text, [instance_num]) |
| FIND Function | The FIND function in Microsoft Excel is a text function that returns the position of a specific text or a character within a text string. Syntax for the FIND function is =FIND(find_text, within_text, [start_num]) |
| SEARCH Function | The SEARCH function in Microsoft Excel allows you to find the position of a specific character or substring within a text string. This function is case insensitive which means it will find the specified text whether it is in uppercase or lowercase. The syntax for the SEARCH function is, =SEARCH(find_text, within_text, [start_num]) |
| REPLACE Function | The REPLACE function in Microsoft Excel replaces characters within a text string with new characters. This function is particularly useful when you want to modify specific portions of a text string without altering the rest. The syntax for the REPLACE function is =REPLACE(old_text, start_num, num_chars, new_text) |
| CONCAT Function | The CONCAT function in Excel allows you to concatenate multiple text strings into a single string. This function is useful when you need to combine text from different cells or add specific characters between text strings. The syntax for the CONCAT function is =CONCAT(text1, [text2], …) |
| CHAR Function | The CHAR function in Excel allows you to retrieve the character associated with a specific numeric value in the character set used by your computer. This function is particularly useful when working with special characters that cannot be easily typed or displayed. The syntax for the CHAR function is =CHAR(number) |
| UNICHAR Function | The UNICHAR function in Excel enables you to fetch the Unicode character associated with a specified numeric value in the Unicode character set. This function proves invaluable when dealing with special characters that might not be readily accessible or visible through regular typing methods. The syntax for the UNICHAR function is =UNICHAR(number) |
| VALUE Function | The VALUE function in Excel allows you to convert a text string that represents a number into an actual numeric value. This function is helpful when you need to perform mathematical operations on text-formatted numbers. The syntax for the VALUE function is =VALUE(text) |
| EXACT Function | The EXACT function in Excel allows you to compare two text strings and determine if they are identical. This function is case-sensitive, meaning it considers uppercase and lowercase characters as distinct. The syntax for the EXACT function is =EXACT(text1, text2) |
| CLEAN Function | The CLEAN function in Excel allows you to remove non-printable characters from a text string. This function is useful when working with imported data that contains special characters that cannot be displayed or printed. The syntax for the CLEAN function is =CLEAN(text) |
| TEXT Function | The TEXT function in Excel empowers you to format and display data in various ways, including custom date and number formatting. This function proves invaluable when you need to transform data into a specific text format for better readability and presentation. The syntax for the TEXT function is =TEXT(value, format_text) |
| TEXTJOIN Function | The TEXTJOIN function in Excel empowers you to combine and join text from multiple cells into one cohesive string, with optional delimiters between each piece of text. This function is particularly valuable when you need to concatenate data from various cells or ranges for a unified presentation. The syntax for the TEXTJOIN function is =TEXTJOIN(delimiter, ignore empty, text1, [text2], …) |
| TEXTBEFORE Function | The Excel TEXTBEFORE function is your key to precision in text extraction. Extract portions of text before a designated delimiter. Allowing you to efficiently manage and manipulate your data. The syntax for the TEXTBEFORE function is =TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]). |
| TEXTAFTER Function | The Excel TEXTAFTER function is a powerful tool for precise text extraction. It enables you to effortlessly capture text portions after a specified delimiter, streamlining your data management and manipulation tasks. The syntax for the TEXTAFTER function is =TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) |
| TEXTSPLIT Function | The Excel TEXTSPLIT function is your data wrangling assistant! It simplifies the task of breaking down text into smaller chunks based on a chosen separator. Whether you’re dealing with names, addresses, or any text strings, TEXTSPLIT helps you neatly organize and dissect your data. The syntax for the TEXTAFTER function is =TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) |
Date & Time Functions
| Excel Functions | Description |
| DAY Function | The DAY function in Excel is a date function that extracts the day from a given date. It enables you to retrieve the day component of a date value and use it for various calculations or further analysis. Syntax for the DAY Function is =DAY(serial_number) |
| DATE Function | The DATE function is used to create a date value by specifying the year, month, and day as individual arguments. It is particularly useful when you want to construct a date based on separate numeric inputs. Syntax for the DATE Function is =DATE(year, month, day) |
| DATEVALUE Function | The DATEVALUE function is used to convert a text string that represents a date into a date value that Excel recognizes. This function is handy when you need to work with dates in a format that Excel does not automatically recognize. Syntax for the DATEVALUE Function is =DATEVALUE(date_text) |
| SECOND Function | The SECOND function allows you to extract the seconds from a given time value. It is useful when you want to focus solely on the seconds component of a time value for analysis or calculations. Syntax for the SECOND Function is =SECOND(serial_number) |
| MINUTE Function | The MINUTE function enables you to extract the minutes from a given time value. With this function, you can easily isolate the minutes component and use it for further calculations or analysis. Syntax for the MINUTE Function is =MINUTE(serial_number) |
| HOUR Function | The HOUR function in Excel allows you to extract the hour from a given time value. It is particularly useful when you need to work with the hour component separately for specific calculations or analysis. Syntax for the HOUR Function is =HOUR(serial_number) |
| NOW Function | The NOW function is a date and time function that returns the current date and time as a serial number. It is dynamic and updates automatically whenever there is a change in the spreadsheet. Syntax for the NOW Function is =NOW() |
| TODAY Function | The TODAY function returns the current date without the time component. It is perfect for situations where you need to work with the current date only and exclude the time portion. Syntax for the TODAY Function is =TODAY() |
| NETWORKDAYS Function | The NETWORKDAYS function calculates the number of working days between two given dates, excluding weekends and optionally considering specified holidays. It is a valuable tool for tasks that require counting business days or calculating project durations. Syntax for the NETWORKDAYS Function is =NETWORKDAYS(start_date, end_date, [holidays]) |
| NETWORKDAYS.INTL Function | Like the NETWORKDAYS function, the NETWORKDAYS.INTL function calculates the number of working days between two dates, considering weekends and specified holidays based on custom settings. It provides flexibility for businesses that operate on non-standard weekends. Syntax for the NETWORKDAYS.INTL Function is =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) |
| WORKDAY Function | The WORKDAY function allows you to calculate a future or past date by excluding weekends and specified holidays. It is helpful for scenarios where you need to determine the deadline for a project or schedule activities based on working days. Syntax for the WORKDAY Function is =WORKDAY(start_date, days, [holidays]) |
| WORKDAY.INTL Function | The WORKDAY.INTL function is an extension of the WORKDAY function that considers weekends and specified holidays based on custom settings. It provides enhanced flexibility for organizations with non-standard workweek configurations. Syntax for the WORKDAY.INTL Function is =WORKDAY.INTL(start_date, days, [weekend], [holidays]) |
| WEEKDAY Function | The WEEKDAY function in Excel returns the day of the week as a number for a given date. It is useful when you need to categorize or analyze data based on the day of the week. Syntax for the WEEKDAY Function is =WEEKDAY(serial_number, [return_type]) |
| DATEDIF Function | The DATEDIF function calculates the difference between two dates in terms of years, months, or days. It is useful when you need to determine the duration between two dates for various purposes. Syntax for the DATEDIF Function is =DATEDIF(start_date, end_date, unit) |
Logical Functions
| Excel Functions | Description |
| AND Function | The AND function in Excel is a logical function that checks if all the given conditions are true. It returns TRUE if all the conditions are met, and FALSE otherwise. Syntax for the AND function is =AND(logical1, logical2, …) |
| OR Function | The OR function in Excel is a logical function that checks if any of the given conditions are true. It returns TRUE if at least one condition is true, and FALSE if all conditions are false. Syntax for the OR function is =OR(logical1, logical2, …) |
| NOT Function | The NOT function in Excel is a logical function that reverses the logical value of a given condition. It returns TRUE if the condition is false, and FALSE if the condition is true. Syntax for the NOT function is =NOT(logical) |
| IF Function | The IF function in Excel is a logical function that performs a specific action based on a given condition. It allows you to define different outcomes based on whether the condition is true or false. Syntax for the IF function is =IF(logical_test, value_if_true, value_if_false) |
| IFS Function | The IFS function in Excel is a logical function that checks multiple conditions and returns the corresponding value of the first true condition. It allows you to simplify complex nested IF statements. Syntax for the IFS function =IFS(logical_test1, value_if_true1, logical_test2, value_if_true2, …, value_if_false) |
| IFERROR Function | The IFERROR function in Excel is a logical function that allows you to handle errors in formulas by returning a specific value or action instead of an error message. Syntax for the IFERROR function is =IFERROR(value, value_if_error) |
Math Functions
| Excel Functions | Description |
| ABS Function | The Excel ABS function is a fundamental tool for numeric operations. It calculates the absolute value of a number, making it positive regardless of its original sign. Syntax for the ABS function is =ABS(number). |
| AGGREGATE Function | The Excel AGGREGATE function is a versatile tool for performing various calculations on data, offering functions like SUM, AVERAGE, MAX, MIN, and more. It can handle error values and hidden rows, providing advanced data analysis capabilities. Syntax for the SUM function is =AGGREGATE(function_num, options, ref1, [ref2], …) |
| SUBTOTAL Function | The Excel SUBTOTAL function is a versatile tool for performing calculations on data ranges, including functions like sum, average, maximum, and more. It’s especially useful for filtered data and has a syntax like this: =SUBTOTAL(function_num, ref1, [ref2], […]) |
| SUM Function | The SUM function is one of the fundamental arithmetic functions in Excel. It allows you to add up a range of cells and obtain the sum. Syntax for the SUM function is =SUM(number1, [number2], […]) |
| SUMIF Function | The SUMIF function is useful when you want to sum values based on specific criteria. It adds up the values in a range that meet a given condition. Syntax of the SUMIF function is =SUMIF(range, criteria, [sum_range]) |
| SUMIFS Function | Like the SUMIF function, the SUMIFS function allows you to sum values based on multiple criteria. It adds up the values in a range that meets multiple conditions simultaneously. Syntax of the SUMIFS function is =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], […]) |
| SUMPRODUCT Function | The SUMPRODUCT function is a versatile function that allows you to perform calculations on multiple ranges or arrays and returns the sum of the products. It is particularly handy when dealing with arrays and performing complex calculations. Syntax of the SUMPRODUCT function is =SUMPRODUCT(array1, [array2], […]) |
| SEQUENCE function | The Excel SEQUENCE function is a dynamic tool that helps you create sequential lists of numbers or dates with ease. It’s a versatile function, particularly useful for generating arrays of values, and its syntax is straightforward: =SEQUENCE(rows, [columns], [start], [step]). |
| ROUND Function | The ROUND function is used to round a number to a specified number of decimal places. It is commonly employed when you need to present data in a more readable or concise format. Syntax of the ROUND function is =ROUND(number, [num_digits]) |
| ROUNDUP Function | The ROUNDUP function in Excel is essential for rounding numbers up to a specified number of decimal places, ensuring that the result is never rounded down. It’s a crucial tool for precision in financial, scientific, and analytical tasks. The syntax is =ROUNDUP(number, num_digits). |
| ROUNDDOWN Function | The ROUNDDOWN function in Excel is used to round numbers down to a specified number of decimal places, ensuring the result is always rounded down and not up. It’s a critical tool for precision in financial, scientific, and analytical calculations. The syntax is =ROUNDDOWN(number, num_digits). |
| MOD Function | The MOD function calculates the remainder when one number is divided by another. It is often used in various scenarios, such as checking for divisibility or cycling through values. Syntax of the MOD function is =MOD(number, divisor) |
| INT Function | The INT function is used to round a number down to the nearest integer. It truncates the decimal part and returns only the integer portion. Syntax of the INT function is =INT(number) |
| RAND Function | The RAND function generates a random number between 0 and 1. It is frequently used when you need to introduce randomness or simulate data. Syntax of the RAND function is =RAND() |
| RANDBETWEEN Function | The RANDBETWEEN function is employed to generate a random integer between two specified values, inclusive. It is handy for scenarios where you need to generate random numbers within a specific range. Syntax of the RANDBETWEEN function is =RANDBETWEEN(bottom, top) |
Lookup & Reference Functions
| Excel Functions | Description |
| CHOOSE Function | The Excel CHOOSE function lets you pick a specific value from a list of options based on an index. It is a valuable tool for making data-driven decisions in your spreadsheets. Syntax: =CHOOSE(index_num, value1, [value2], …). |
| CHOOSECOLS Function | The CHOOSECOLS function in Excel for Microsoft 365 enables you to select and extract specific columns from an array. This function is a valuable tool for simplifying data extraction tasks within your spreadsheets. The syntax is as follows: =CHOOSECOLS(array, col_num1, [col_num2], …). |
| CHOOSEROWS Function | The CHOOSEROWS function in Excel for Microsoft 365 allows you to extract specific rows from an array, providing a convenient way to work with selective data in your spreadsheets. The syntax is as follows: =CHOOSEROWS(array, row_num1, [row_num2], …). |
| COLUMN Function | The COLUMN function in Excel returns the column number of a specified cell reference. It is often used in combination with other functions to perform calculations based on column positions. Syntax for the COLUMN function is =COLUMN([reference]) |
| COLUMNS Function | The COLUMNS function in Excel counts the number of columns within a range or an array. It is especially handy when working with multi-column data sets or when you want to know the width of a range. Syntax for the COLUMNS function is =COLUMNS(reference) |
| DROP Function | The DROP function in Excel for Microsoft 365 allows you to exclude a specified number of rows or columns from the beginning or end of an array. This function is a practical tool for customizing your data by removing unwanted headers, footers, or other non-essential information from your Excel reports. The syntax is as follows: =DROP(array, rows, [columns]). |
| EXPAND Function | The EXPAND function in Excel for Microsoft 365 allows you to effortlessly adjust the dimensions of an array, expanding or padding it to fit specified row and column dimensions. The syntax is as follows: =EXPAND(array, rows, [columns], [pad_with]). |
| FILTER Function | The FILTER function in Excel allows you to extract a subset of data from a range based on specified criteria. It returns an array that meets the specified conditions. Syntax for the FILTER function is =FILTER(array, include, [if_empty]) |
| HLOOKUP Function | The HLOOKUP function in Excel searches for a specified value in the top row of a table or range and returns the corresponding value from a specified row. It is commonly used for horizontal data lookup operations. Syntax for the HLOOKUP function is =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) |
| HSTACK function | The HSTACK function in Excel helps put information from different columns side by side. It is like sticking them together horizontally. Syntax for the HSTACK function is =HSTACK(array1, [array2], […]). |
| IMAGE Function | The IMAGE function in Excel for Microsoft 365 enables you to insert images from external sources into cells, along with alternative text for accessibility. The syntax is as follows: =IMAGE(source, [alt_text], [sizing], [height], [width]). |
| INDEX Function | The INDEX function in Excel returns the value of a cell within a specified range based on its row and column numbers. It is commonly used for data lookup and retrieval operations. Syntax for the INDEX function is =INDEX(array, row_num, [column_num]) |
| INDIRECT Function | The INDIRECT function in Excel allows you to create a reference to a cell or range indirectly. It is commonly used in situations where you want to dynamically refer to a cell based on its text representation or the result of another formula. Syntax for the INDIRECT function is =INDIRECT(ref_text, [a1]) |
| LOOKUP Function | The LOOKUP function in Excel is a powerful tool for searching and retrieving specific data from a table or range. It is commonly used to find a value in one column and return a corresponding value from another column. The syntax for the LOOKUP function is =LOOKUP(lookup_value, lookup_vector, [result_vector]). |
| MATCH Function | The MATCH function in Excel searches for a specified value within a range and returns its relative position. It is widely used for data lookup and matching purposes. Syntax for the MATCH function is =MATCH(lookup_value, lookup_array, [match_type]) |
| OFFSET Function | The OFFSET function in Excel returns a cell or range reference that is a specified number of rows and columns away from a given reference point. It is often used in combination with other functions to create dynamic ranges or perform calculations based on relative positions. Syntax for the OFFSET function is =OFFSET(reference, rows, cols, [height], [width]) |
| ROW Function | The ROW function in Excel returns the row number of a specified cell reference. It is often used in conjunction with other functions to manipulate data based on row positions. Syntax for the ROW function is =ROW([reference]) |
| ROWS Function | The ROWS function in Excel counts the number of rows within a range or an array. It is particularly useful when dealing with multi-row datasets or when you need to determine the height of a range. Syntax for the ROWS function is =ROWS(reference) |
| SORT Function | The Excel SORT function is a powerful tool for arranging the data in a selected range in ascending or descending order based on specified criteria. The syntax for the SORT function is as follows: =SORT(array, [sort_index], [sort_order], [by_col]). |
| SORTBY Function | The Excel SORTBY function is a versatile tool for sorting data within a selected range based on the values in another range or array. This function allows you to sort data in ascending or descending order according to the values in a separate column or array, providing more flexibility in how you organize and present your data. The syntax for the SORTBY function is as follows: =SORTBY(array, by_array1, [sort_order1], [by_array2], [sort_order2], …). |
| TAKE Function | The Excel TAKE function allows you to easily extract a specific number of rows or columns from the start or end of an array. Its syntax is =TAKE(array, rows, [columns]). |
| TOCOL Function | The Excel TOCOL function is a valuable tool for converting an array or reference into a single column, making data manipulation and presentation more convenient. Its syntax is =TOCOL(array, [ignore], [scan_by_column]). |
| TOROW Function | The Excel TOROW function allows you to convert an array or reference into a single row, streamlining data manipulation and presentation. Its syntax is =TOROW(array, [ignore], [scan_by_column]). |
| TRANSPOSE Function | The Excel TRANSPOSE function is a powerful tool for reorganizing data within a worksheet. It allows you to switch the rows and columns of a range or array, effectively transforming horizontal data into a vertical format or vice versa. The syntax for the TRANSPOSE function is simple: =TRANSPOSE(array). |
| UNIQUE Function | The Excel UNIQUE function is a valuable tool for extracting distinct values from a given range or array. It helps you filter out duplicates, leaving you with a list of unique values. The syntax for the UNIQUE function is as follows: =UNIQUE(array, [by_col], [exactly_once]). |
| VLOOKUP Function | The VLOOKUP function in Excel searches for a specified value in the first column of a table or range and returns the corresponding value from a specified column. It is commonly used for vertical data lookup operations. Syntax for the VLOOKUP function is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) |
| VSTACK function | The VSTACK function in Excel is a useful tool for vertically stacking or combining arrays, making it easy to organize data from various rows. Syntax for the VLOOKUP function is =VSTACK(array1, [array2], […]). |
| WRAPCOLS Function | The Excel WRAPCOLS function is a valuable tool for converting a row or column of values into a structured 2-dimensional array with multiple columns, based on your specified criteria. Syntax for the WRAPCOLS function is =WRAPCOLS(vector, wrap_count, [pad_with]). |
| WRAPROWS Function | The Excel WRAPROWS function is a valuable tool that allows you to transform a row or column of values into a structured 2-dimensional array organized by rows, based on your specified criteria. Syntax for the WRAPROWS function is =WRAPROWS(vector, wrap_count, [pad_with]). |
| XLOOKUP Function | The XLOOKUP function in Excel is a powerful replacement for both HLOOKUP and VLOOKUP functions. It searches for a specified value in a table or range and returns the corresponding value from the same position. Syntax for the XLOOKUP function is =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) |
Financial Functions
| Excel Functions | Description |
| PMT Function | The PMT function is a financial function in Excel that calculates the periodic payment for a loan or investment with constant payments and a constant interest rate. It is commonly used to determine the fixed payment amount required to pay off a loan over a specific period. Syntax for the PMT function is =PMT(rate, nper, pv, [fv], [type]) |
| PPMT Function | The PPMT function is another financial function in Excel that calculates the principal payment for a specific period in a loan or investment with constant payments and a constant interest rate. It helps in determining the principal portion of each payment. Syntax for the PPMT function is =PPMT(rate, per, nper, pv, [fv], [type]) |
| IPMT Function | The IPMT function, like the PPMT function, is a financial function that calculates the interest payment for a specific period in a loan or investment with constant payments and a constant interest rate. It helps in determining the interest portion of each payment. Syntax for the IPMT function is =IPMT(rate, per, nper, pv, [fv], [type]) |
| NPER Function | The NPER function is a financial function that calculates the number of periods required to pay off a loan or investment with regular payments and a constant interest rate. It is commonly used to determine the duration needed to repay a loan. Syntax for the NPER function is =NPER(rate, pmt, pv, [fv], [type]) |
| NPV Function | The NPV function is a financial function that calculates the net present value of an investment by discounting the cash flows at a specified rate of return. It helps in assessing the profitability of an investment. Syntax for the NPV function is =NPV(rate, value1, [value2], …) |
| PV Function | The PV function is a financial function that calculates the present value of an investment, which is the initial investment required to achieve a future value at a specific interest rate. It helps in determining the value of an investment today. Syntax for the PV function is =PV(rate, nper, pmt, [fv], [type]) |
| FV Function | The FV function is a financial function that calculates the future value of an investment based on periodic constant payments and a constant interest rate. It helps in determining the value of an investment at a future date. Syntax for the FV function is =FV(rate, nper, pmt, [pv], [type]) |
| IRR Function | The IRR function is a financial function that calculates the internal rate of return for a series of cash flows. It helps in evaluating the profitability of investment by determining the discount rate that makes the net present value of the cash flows equal to zero. Syntax for the IRR function is =IRR(values, [guess]) |
Statistical Functions
| Excel Functions | Description |
| AVERAGE Function | The AVERAGE function calculates the arithmetic mean of a range of values in Excel. It is often used to determine the average value of a set of numbers. To use the AVERAGE function, you can input the range of cells containing the numbers as the argument. Syntax for the AVERAGE function is =AVERAGE(number1, [number2], …) |
| AVERAGEIF Function | The AVERAGEIF function allows you to calculate the average of a range of values based on specified criteria. It provides a way to include only those values that meet a certain condition. Syntax for the AVERAGEIF function is =AVERAGEIF(range, criteria, [average_range]) |
| AVERAGEIFS Function | Like the AVERAGEIF function, the AVERAGEIFS function calculates the average of a range of values based on multiple criteria. It allows you to specify multiple conditions using different ranges. Syntax for the AVERAGEIFS function is =AVERAGEIFS(average_range, range1, criteria1, [range2], [criteria2], …) |
| COUNT Function | The COUNT function is used to count the number of cells in a range that contain numerical values. It excludes empty cells, text, and logical values from the count. To utilize the COUNT function, you can specify the range of cells as the argument. Syntax for the COUNT function is =COUNT(value1, [value2], …) |
| COUNTA Function | The COUNTA function counts the number of non-empty cells in a range. It includes cells containing text, values, and logical values in the count. To use the COUNTA function, you can provide the range of cells as the argument. Syntax for the COUNTA function is =COUNTA(value1, [value2], …) |
| COUNTBLANK Function | The COUNTBLANK function enables you to count the number of empty cells within a specified range. It excludes cells that contain any value or text. To utilize the COUNTBLANK function, you need to provide the range of cells as the argument. Syntax for the COUNTBLANK function is =COUNTBLANK(range) |
| COUNTIF Function | The COUNTIF function allows you to count the number of cells in a range that meet a specific condition. It enables you to include only those cells that satisfy a particular criterion. Syntax for the COUNTIF function is =COUNTIF(range, criteria) |
| COUNTIFS Function | The COUNTIFS function extends the functionality of the COUNTIF function by enabling you to count cells based on multiple criteria. It allows you to specify multiple conditions using different ranges. Syntax for the COUNTIFS function is =COUNTIFS(range1, criteria1, [range2], [criteria2], …) |
| LARGE Function | The LARGE function helps you find the nth largest value within a dataset. It allows you to identify the largest values based on their position in the order. Syntax for the LARGE function is =LARGE(array, k) |
| MAX Function | The MAX function is used to find the highest value in a range of cells. It returns the maximum value among the specified values or cell references. To utilize the MAX function, you can input the range of cells or individual values as the argument. Syntax for the MAX function is =MAX(number1, [number2], …) |
| MIN Function | The MIN function helps you find the lowest value in a range of cells. It returns the minimum value among the specified values or cell references. To use the MIN function, you can input the range of cells or individual values as the argument. Syntax for the MIN function is =MIN(number1, [number2], …) |
| SMALL Function | The SMALL function allows you to find the nth smallest value within a dataset. It helps you identify the smallest values based on their position in the order. Syntax for the SMALL function is =SMALL(array, k) |
Information Functions
| Excel Functions | Description |
| ISBLANK Function | The ISBLANK function is a logical function in Excel that helps determine whether a cell is empty or contains no data. It returns TRUE if the specified cell is blank and FALSE if it contains any value or formula. Syntax for the ISBLANK function is =ISBLANK(value) |
| ISERROR Function | The ISERROR function is another valuable Excel function that helps identify whether a cell contains any error value. It returns TRUE if the specified cell contains an error value and FALSE otherwise. Syntax for the ISERROR function is =ISERROR(value) |
| ISNUMBER Function | The ISNUMBER function enables you to identify whether a cell contains a numeric value. It returns TRUE if the cell contains any numeric value and FALSE if it contains any other data type, such as text or error values. Syntax for the ISNUMBER function is =ISNUMBER(value) |
| ISEVEN Function | The ISEVEN function is a useful tool for determining whether a specified number is even. It returns TRUE if the number is even and FALSE if it is odd. Syntax for the ISEVEN function is =ISEVEN(value) |
| ISODD Function | Like the ISEVEN function, the ISODD function helps identify whether a number is odd. It returns TRUE if the number is odd and FALSE if it is even. Syntax for the ISODD function is =ISODD(value) |
| ISLOGICAL Function | The ISLOGICAL function allows you to check whether a cell contains a logical (Boolean) value. It returns TRUE if the cell contains a logical value and FALSE if it contains any other data type. Syntax for the ISLOGICAL function is =ISLOGICAL(value) |
| ISTEXT Function | The ISTEXT function is used to determine whether a cell contains text. It returns TRUE if the cell contains any text and FALSE if it contains any other data type, such as numbers or error values. Syntax for the ISTEXT function is =ISTEXT(value) |