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

Functions 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 …

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

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

Learn best practices and ways to prevent formula errors caused by common mistakes.

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

Lists all Excel functions by their category, such as Logical functions or Text functions.

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 …

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.

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.

The workbook below shows examples simple formulas. You can change any of the existing formulas, or enter your own formulas to learn how they work and see their results.