> ## Content Index
> Fetch the complete content index at: https://aabie.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Use Excel Basic Formulas and Check That They Work
- URL: https://aabie.com/how-to-use-excel-basic-formulas/
- Published: 2026-11-11T01:53:28.000Z
- Updated: 2026-11-11T01:53:28.000Z
- Description: Use Excel basic formulas to make calculations instead of typing fixed numbers. This walkthrough shows what to enter, how to copy formulas safely, and how to check that each result matches the source cells.
- Author: Aabie Editorial Team
- Tags: Education

[Use a basic Excel](https://aabie.com/excel-basics-beginners/) formula when you want Excel to calculate a result instead of storing a fixed number. A basic formula is different from a typed value because Excel does the math for you after you start with \`=\`. In this walkthrough, you’ll enter a few simple formulas, copy them safely, and check that the results match the source cells.

## What you need before you start

Open a blank worksheet and put a few sample numbers in nearby cells. You also need one empty cell where you can test a formula without changing anything else.

If you want to follow the examples exactly, type a small set of numbers in a row or column, such as values in `A1:A5` and `B1:B5`. The exact numbers do not matter. What matters is that you have something to add, average, count, or compare.

You should also know that a formula only works if Excel can read the cells you point to. If a cell is blank, contains text when you expected a number, or the range is wrong, the result can be off or an error can appear.

## The one rule every formula follows

Every Excel formula starts with an equals sign: `=`. If you leave that off, Excel treats what you typed as plain text or a value instead of calculating it.

For example, typing `=2+2` makes Excel show the result `4`. Typing `2+2` by itself usually just displays the text `2+2` in the cell. That single symbol is the difference between a formula and a typed value.

A formula is a set of instructions. A value is the finished number or text that sits in the cell. When you enter a formula, Excel stores the formula behind the scenes and shows the calculated result on the sheet.

## Start with the simplest formulas first

Begin with one formula, then build up. That makes it easier to spot mistakes and easier to tell whether Excel is doing what you meant.

1. Add two cells together with simple arithmetic. If `A1` has `10` and `B1` has `5`, click an empty cell and type:

```text
=A1+B1
```

Simple addition

Press Enter. Excel should show `15`.

Check it by looking at the formula bar and comparing the two source cells. If one of those cells changes, the result should change too.

1. Use `SUM` to add a range. If you have numbers in `A1:A5`, click a blank cell and type:

```text
=SUM(A1:A5)
```

SUM formula

Press Enter. `SUM` adds every number in that range. This is usually easier than typing `=A1+A2+A3+A4+A5`.

Check the result by making sure the highlighted range includes every cell you meant to total. If the number looks low, the range is often too short.

1. Use `AVERAGE` to find the mean of a range. With numbers in `B1:B5`, type:

```text
=AVERAGE(B1:B5)
```

AVERAGE formula

Press Enter. Excel returns the average of the numbers in that range.

Check the result by confirming that the range does not include an extra blank cell or an unrelated value. Either one can change the answer.

1. Use `MIN` to find the smallest number. With values in `C1:C5`, type:

```text
=MIN(C1:C5)
```

MIN formula

Press Enter. The result is the smallest number in the range.

Check it by scanning the source cells yourself. The smallest value on the sheet should match the number Excel returns.

1. Use `MAX` to find the largest number. With values in `D1:D5`, type:

```text
=MAX(D1:D5)
```

MAX formula

Press Enter. The result is the largest number in the range.

Check it the same way: compare the result with the largest number you can see in the source cells.

1. Use `COUNT` to count cells that contain numbers. With numeric values in `E1:E5`, type:

```text
=COUNT(E1:E5)
```

COUNT formula

Press Enter. `COUNT` tells you how many cells in the range contain numbers, not text.

Check it by counting only the cells with numeric values. If a cell looks like a number but Excel ignores it, it may be stored as text.

If you prefer menus, Excel also has AutoSum on the ribbon. It can insert `SUM`, and in many versions it can suggest nearby ranges automatically. Still, I recommend typing the formula yourself at first so you can see exactly what range Excel is using.

## How cell references work without the jargon

A cell reference is just a cell address, like `A1` or `B7`. Instead of hard-coding a number into a formula, you point the formula at a cell and let Excel use whatever value is in that cell.

That matters because formulas are often copied. A reference that changes when you copy a formula is called a relative reference. If a formula in row 2 says `=A2+B2` and you copy it down one row, Excel normally changes it to `=A3+B3`.

An absolute reference stays fixed when you copy the formula. You make one by adding dollar signs, like `$A$1`. If a formula uses `=$A$1+B1` and you copy it down, the `$A$1` part stays on `A1`.

Use a relative reference when you want the formula to move with the row or column. Use an absolute reference when every copied formula should keep pointing to the same cell, such as a tax rate, discount rate, or fixed label value. If only part of the reference should stay fixed, lock only that part with `$`.

![A laptop screen shows a spreadsheet with several cells highlighted.](https://tse1.mm.bing.net/th?q=laptop%20spreadsheet%20with%20cell%20references&w=624&h=352&c=7)

## Copy a formula down or across the safe way

Copying a formula is where many beginners get confused, because the result changes and it feels like something broke. Usually the formula is fine; the reference behavior changed in the way Excel is supposed to change it.

1. Enter one working formula in the first cell.
2. Click the cell, then use the fill handle, which is the small square at the bottom-right corner of the selected cell, to drag the formula down or across.
3. Watch the formulas in the new cells. Excel should adjust relative references automatically.
4. Click one of the copied cells and look in the formula bar. That is the quickest way to confirm whether Excel moved the references the way you expected.

If you prefer, you can also copy and paste the cell. That does the same basic job. The important part is to check the copied formula after the paste.

Say your first formula is `=A2*B2` in `C2`. When you copy it to `C3`, you usually want it to become `=A3*B3`. If it instead keeps pointing to the wrong cells, you likely need an absolute reference for the part that should not move.

![A hand is dragging the fill handle in a spreadsheet on a laptop screen.](https://tse1.mm.bing.net/th?q=laptop%20spreadsheet%20fill%20handle%20being%20dragged&w=624&h=352&c=7)

## How to edit a formula after entering it

Click the cell and then edit the formula in the formula bar, or press the edit key if that is how you normally work in Excel. You do not need to retype the whole formula just to change one reference.

If the formula is already copied down a column, edit the top cell first and then copy the corrected version again. That is usually safer than fixing each copied cell by hand.

After you edit it, press Enter and check the result again. If the output changes in a way that surprises you, compare the formula bar with the source cells before you move on.

## How to tell the formula worked

Use three checks: the visible result, the formula bar, and a quick hand check against the source numbers. If all three line up, you can trust the formula.

First, look at the number shown in the cell. That is the calculated result. Then click the cell and read the formula bar to confirm the formula is what you meant to type. Finally, compare the result with the values in the referenced cells.

A quick sanity check catches most beginner errors before they spread across a sheet. If you summed `A1:A5`, make sure the range really includes the rows you intended and does not stop one row too early. A formula can look right and still be wrong if the range is off by one cell or includes a blank cell you did not mean to use.

## Common beginner mistakes and quick fixes

The most common mistake is forgetting the equals sign. If Excel shows your formula as text instead of a result, go back and add `=` at the front.

Another common problem is numbers stored as text. In that case, `SUM` or `COUNT` may ignore them. You may see little warning markers, or the totals may come out lower than expected. Convert the cells to real numbers before trusting the formula.

Wrong ranges cause a lot of confusion too. If your `SUM` or `AVERAGE` looks off, click the formula and check the highlighted cells. The range may be too short, too long, or pointing at the wrong column.

Copied formulas can also surprise you if a reference moved when it should have stayed fixed. That is when you usually need `$` in the reference. Use an absolute reference for the fixed cell and relative references for the parts that should change.

If Excel shows an error value, pause and check the formula instead of copying it farther down. Common ones include these:

- `#VALUE!` often means one of the cells contains text where Excel expected a number.
- `#DIV/0!` usually means a formula tried to divide by zero or by a blank cell.
- Other errors can mean the range is invalid or a referenced cell was deleted.

The fix is usually in the inputs, not the function name. Read the formula bar, inspect the referenced cells, and correct the source values or the range. If the exact message varies, use the message itself as your clue and check the current source cells and formula first.

## Quick formula cheat sheet you can reuse

These are the basic Excel formulas most beginners use again and again:

- `=SUM(A1:A5)` adds the numbers in a range.
- `=AVERAGE(B1:B5)` finds the average of the numbers in a range.
- `=MIN(C1:C5)` returns the smallest value.
- `=MAX(D1:D5)` returns the largest value.
- `=COUNT(E1:E5)` counts the cells with numbers.
- `=A1+B1` adds two cells together.

Keep in mind that the range you choose matters as much as the function itself. If the result looks wrong, check the cells first, then the formula.

## Conclusion

When you can enter a formula, copy it, edit it, and check the formula bar against the source cells, you’ve got the basics working. In the sheet itself, that usually looks like a result in the cell, the same formula pattern copied down the row or column, and no surprise errors.

## Frequently Asked Questions

### How do I edit a formula after I’ve entered it?

Click the cell and edit the formula in the formula bar instead of retyping it from scratch. That is usually faster and safer, especially when you only need to change one cell reference or one part of the range.

### Why does Excel show an error instead of a result?

Excel usually shows an error because one input is wrong, missing, or treated as text. Check the formula bar, look at the referenced cells, and confirm the range and data type are what you intended before you copy the formula farther down.