Overview of formulas - Microsoft Support
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Overview of formulas in Excel - Microsoft Support
Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Formulas and functions - Microsoft Support
Learn these top skills to create your own formulas and functions.
Calculate the difference between two dates - Microsoft Support
We'll do this by writing a different kind of formula, shown above. This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016).
Use Excel built-in functions to find data in a table or a range of ...
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. This …
Calculate the difference between two times in Excel
There are several ways to calculate the difference between two times. There are two approaches that you can take to present the results in the standard time format (hours : minutes : …
IF function – nested formulas and avoiding pitfalls
Let's look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it's time to use another tool in your Excel arsenal. Following is an example of …
Excel functions (by category) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.
Enter a formula - Microsoft Support
Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. …
Examples of commonly used formulas - Microsoft Support
Find links to examples of commonly-used formulas, including some video examples.