How to Use Formulas in Excel

Excel formulas are one of the most useful features of the program. Once you learn the basic format of creating a formula, Excel does all the calculations for you.

These tutorials cover basic Excel math operations. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how.

This tutorial covers using formulas and functions in a basic Excel spreadsheet. The tutorial includes step by step examples of creating formulas in Excel. Part 2 of the tutorial covers formatting the spreadsheet

Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.

A multiple cell or multi cell array formula is an array formula that is located in more than one cell in a worksheet. Even though the same formula is located in multiple cells, because it is an an array formula each instance or copy of the formula uses different data in its calculations and each instance produces different results.

Single cell array formulas normally first carry out a multi cell array calculation - such as multiplication - and then use a function such as or AVERAGE or SUM to combine the output of the array into a single result.

"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared. Read this article for an overview of how you can use Excel formulas to help you answer questions related to your project.

Using labels in formulas and functions in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January". Using labels in a formula or function is often easier then trying to pin point the exact cell references of your data.

One of Excel's most used features is that it allows you to use formulas to perform calculations on your spreadsheet data. You can use Excel formulas for basic number crunching, such as addition or subtraction, as well as more complex calculations such as payroll deductions or a student's average on test results. Read this article to find out more about using formulas in Excel spreadsheets.