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

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

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

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

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

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.

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.

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.

Date and time: Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. This function is not available in Excel for the …

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.

Create a simple formula to multiply and divide in an Excel spreadsheet. You can multiply two or more numbers in one cell or multiply and divide numbers using cell references. All formulas in Excel begin …