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.
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 …
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 …
TEXTAFTER function - Microsoft Support
Returns text that occurs after given character or string. It is the opposite of the TEXTBEFORE function. =TEXTAFTER (text,delimiter, [instance_num], [match_mode], [match_end], …
Create a simple formula in Excel - Microsoft Support
How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.
Curve text around a circle or other shape - Microsoft Support
You can use WordArt with a Transform text effect to curve or bend text around a shape. If you want the text to circle the shape, you can also do this, but it’s a little bit more work. You can …
How to write formulas that reference data types - Microsoft Support
You can use formulas that reference linked data types. This allows you to retrieve and expose more information about a specific linked data type. In the following example, the linked data …
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the …
Write an equation or formula - Microsoft Support
Learn how to insert, change, or write an equation or formula in Microsoft Word.
Edit titles or data labels in a chart - Microsoft Support
In PivotChart reports, the following procedures reestablish links between data labels and source data (not worksheet cells). On a chart, click the chart or axis title that you want to link to a …
SUMPRODUCT function - Microsoft Support
In this example, we'll use SUMPRODUCT to return the total sales for a given item and size: SUMPRODUCT matches all instances of Item Y/Size M and sums them, so for this example …