Overview of formulas in Excel - Microsoft Support
WEBUsing functions and nested functions in Excel formulas. Define and use names in formulas. Guidelines and examples of array formulas. Delete or remove a formula. How to avoid broken formulas. Find and correct errors in formulas. Excel keyboard shortcuts and function keys. Excel functions (by category)
Excel functions (by category) - Microsoft Support
WEBWorksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
AND function - Microsoft Support
WEBAND function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
IF function - Microsoft Support
WEBUse the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. IF(logical_test, value_if_true, [value_if_false]) For example: =IF(A2>B2,"Over Budget","OK")
Using functions and nested functions in Excel formulas
WEBFunctions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel's functions on the Formulas tab on the Ribbon: Excel function syntax
Excel functions (alphabetical) - Microsoft Support
WEBClick a letter to go to functions that start with it. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Examples of commonly used formulas - Microsoft Support
WEBExamples of commonly used formulas - Microsoft Support. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 More... The following table contains links to articles and videos that show you how to create formulas from the data in your worksheet.
Overview of formulas - Microsoft Support
WEBThe parts of a formula. A formula can also contain any or all of the following: functions, references, operators, and constants. 1. Functions: The PI () function returns the value of pi: 3.142... 2. References: A2 returns the value in cell A2. 3. Constants: Numbers or text values entered directly into a formula, such as 2. 4.
Use Excel built-in functions to find data in a table or a range of ...
WEBUse Excel built-in functions to find data in a table or a range of cells - Microsoft Support. Summary. This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. Create the Sample Worksheet.
Formulas and functions - Microsoft Support
WEBDefine and use names in formulas. Create a simple formula. Display or hide formulas. Move or copy a formula. Display or hide zero values. Use Excel as your calculator. Summing up ways to add and count Excel data. Count how often a value occurs. Find external references (links) in a workbook.
Guidelines and examples of array formulas - Microsoft Support
WEBExcel. Formulas and functions. Guidelines and examples of array formulas. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 More... An array formula is a formula that can perform multiple calculations on one or more items in an array.
Skip to content