How to use the IF function in Excel to make logical comparisons between data values.| support.microsoft.com
Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.| support.microsoft.com
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.| support.microsoft.com
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.| support.microsoft.com
How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.| support.microsoft.com
Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.| support.microsoft.com
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
A complete list of all Excel functions in alphabetical order.| support.microsoft.com
You can use error checking to detect errors in formulas. The rules don't guarantee error-free worksheets, but they can help find common mistakes. Errors can include: Cells containing formulas that result in an error, inconsistent calculated column formula in tables, cells containing years represented as 2 digits, numbers formatted as text or preceded by an apostrophe, formulas inconsistent with other formulas in the region, formulas which omit cells in a region, unlocked cells containing form...| support.microsoft.com
Syntax: COUNTA(value1,value2,...)| support.microsoft.com
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.| support.microsoft.com
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.| support.microsoft.com
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.| support.microsoft.com
Use a LAMBDA function to create custom, reusable functions and call them by a friendly name. The new function is available throughout the workbook and called like native Excel functions.| support.microsoft.com
How to use the FILTER function in Excel to filter a range of data based on criteria you define.| support.microsoft.com
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.| support.microsoft.com