How to build a formula in Excel. - Tutorial

Presented below are the basics for building a formula in a worksheet cell. Formulas are the calculation backbone of Excel and knowing how to type one is essential to exploiting Microsoft Excel's analytical capabilities.

Build Excel Formula

What is an Excel formula and how does it work?

An Excel formula is what you type in a worksheet cell to perform a calculation on a Microsoft Excel worksheet. Basic Microsoft Excel formulas basically look like normal math equations with computer operators standing in for some traditional math operators. The basic operators used in a formula are: Division: /, Multiplication: *, Addition: +,  Subtraction: -, and Power: ^.

To begin a formula in a cell, you type an = sign followed by operators, cell references, and numbers. For example if you typed =16.95 * 25 in a worksheet cell the value returned would be 423.75. To make the formula adaptive, you can replace the 16.95 and 25 with cell references like = C6 * C7. When enter is pressed, the formula will multiply the values that are in cells C6 and C7 and display the value in the cell. If either C6 or C7 is changed in value and Enter is pressed, the formula referencing those cells will recalculate automatically displaying the new value.

What is an Excel Formula and How Does It Work?

Scroll < > picture if hidden.

The example above demonstrates what a formula looks like in a worksheet cell and how it calculates. Input and Output areas are designated on the worksheet to let the user know where information is typed (inputs) and where the formulas are (outputs). While simple in construct, it begins to show how interface construction and organization help a user find things on a worksheet.

How to create an Excel worksheet formula.

Before beginning to create a formula, look at your equations and type all the information they need to calculate on the worksheet. Think about the numbers you punch into a calculator and those are the values to put on a worksheet. To create a formula in a worksheet cell, first begin with an = sign.

Next click on the first cell reference to use in the formula with your mouse or type a value. Next type an operator like + then click on the next cell reference with your mouse or type the next value and so forth. Operators go in between the cell references and values. ( )'s are placed around operations like (4/3) because you want to calculate that operation first before its value is used by other operations.

Repeat this process until you are finished building the formula then press Enter. Note when mixing operators like = 5 + 3 * 2 in a formula, there is an operator precedence which means certain operations occur before others. In this case 3 * 2 runs first followed by + 5. That is why you use ()'s to override this order and force operations to go first like (5+3) then * 2.

How to Create an Excel Worksheet Formula

Scroll < > picture if hidden.

The example above demonstrates how to type a formula in a worksheet cell using the mouse and keyboard. When entering a cell reference in a formula, it is best to click on it with the mouse so you do not make a typing error.

Additional Tutorial Topics:

03/08
< Back
Next >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved