Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

Formulas calculate values in a specific order. A formula always begins with an equal sign (=).

Find links to examples of commonly-used formulas, including some video examples.

Learn these top skills to create your own formulas and functions.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM …

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. For …

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.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …

Find customizable templates to take your project to the next level. Ask questions about your data without having to write complicated formulas. Not available in all locales. Use Analyze Data to make data …

When you start creating formulas, keep the following best practices in mind. It’s also good to be aware of common mistakes you can make when you create formulas.

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.