Understanding Excel Formulas

Microsoft Excel works like a powerful calculator that can perform many different types of mathematical operations. To use these features effectively, you must describe the calculation you want in a way Excel can understand. This tutorial introduces the basics of Excel formulas, including cell references, mathematical operators, autofill and the SUM function.

Every Excel Formula Starts With an Equal Sign

In Excel, formulas must always begin with an equal sign (=).

The equal sign tells Excel that the contents of the cell should be calculated rather than treated as plain text or a simple number. After the equal sign, type everything without using spaces.

For example:

=2+3

This instructs Excel to calculate the result of adding the numbers together.

Without the equal sign, Excel will treat the numbers as ordinary values instead of performing a calculation.

Values vs Cell References

In Excel formulas, there are two main ways to work with numbers.

You can use:

Values – actual numbers typed directly into the formula

or

Cell references – coordinates that point to numbers stored elsewhere in the worksheet.

For example:

=A3+B3

This formula tells Excel to add the numbers stored in cells A3 and B3.

Using references instead of typing numbers directly allows Excel to automatically update results if the underlying data changes.

Basic Mathematical Operators in Excel

Excel formulas use standard mathematical symbols called operators.

The most common operators are:

Addition +

Subtraction -

Multiplication *

Division /

For multiplication, Excel uses an asterisk (*), not the letter X.

For example:

=A1*B1

Using Autofill to Copy Formulas

Excel includes a powerful feature called autofill, which allows formulas to be copied automatically to other rows or columns.

To use autofill:

  1. Select a cell containing a formula

  2. Move the cursor to the small square in the bottom-right corner

  3. Drag the handle downward or across

Excel will automatically adjust the references to match each row or column.

Relative References

Most Excel formulas use relative references.

A relative reference automatically changes when the formula is copied to another location.

For example:

=D1+E1

If this formula is copied down one row, Excel will automatically adjust it to:

=D2+E2

This behavior makes it easy to apply the same calculation across many rows of data.

Using the SUM Function

Excel also provides functions, which are built-in formulas designed for common calculations.

One of the most frequently used functions is SUM.

Example:

=SUM(D1:F1)

This formula adds together all values in the range from D1 to F1.

The colon between the cell references indicates a range, meaning every cell between the two coordinates will be included in the calculation.

The SUM function is often more flexible than manually adding cells together.

Why the SUM Function Is Often Better

The SUM function can automatically adapt when rows or columns are inserted or deleted.

For example, if you add a new column inside the selected range, Excel will usually update the formula to include the new data.

This makes SUM formulas more reliable than manually writing long formulas such as:

=D1+E1+F1

Absolute References

Sometimes you want part of a formula to always refer to the same cell.

This is where absolute references are used.

An absolute reference includes dollar signs:

$I$2

This locks the formula to cell I2, preventing Excel from changing the reference when the formula is copied.

Absolute references are often used when formulas refer to constants such as:

  • tax rates

  • conversion factors

  • fixed multipliers

Example: Calculating Tax in Excel

Imagine you have a column containing subtotals and a single cell containing the tax rate.

A formula like this:

=F2*$I$2

multiplies the subtotal by the tax rate.

Because the tax rate uses an absolute reference, Excel will always refer to that same cell when the formula is copied to other rows.

If the tax rate changes, all calculated results will update automatically.

Why Excel Formulas Are Powerful

Formulas allow Excel to automatically update calculations when your data changes. Instead of recalculating numbers manually, Excel recomputes the results instantly.

Once you understand references, operators and functions, you can use Excel to analyze large amounts of data efficiently.

Related Excel Tutorials

You may also find these tutorials helpful: