Writing Formulas Using Operators and Functions
Operators
are what connects the elements of a formula. Some familiar operators are: addition (+), subtraction (-), multiplication (*), and division (/). There is an
order of operations
when you are evaluating a formula. Formulas are evaluated from left to right, with expressions enclosed in parentheses evaluated first, then exponents, multiplication, division, addition, and subtraction. Excel has many more operators, but we will work with the operators listed above for now.
Here is an example of how the order of operations works:
If you have the following formula within a cell;
=A8/(A9+A4)
The first operation would be the sum of A9 and A4 and then A8 would be divided by that sum.
Describing Formulas
Excel allows you to add comments to explain the purpose of an inserted formula. The comments are displayed in the
Cell Note
window which can be viewed by choosing
Note
from the
Insert
menu. Let's enter a formula using operators and comment the formula.
Open a new workbook window.
Starting in cell A1 build the following table:
You are going to enter a formula which will calculate the average of these nine grades.
Select cell A11 and type in the text:
Total
.
It would be best if the total sum of the grades was beneath the last grade. You need to insert a column between column A and column B so you don't have to retype all the numbers.
Insert a Column
Highlight column A by clicking in the column heading.
Observe:
Choose
Columns
from the
Insert
menu.
Column A should be a blank column now.
Select cell B1 and click in the formula bar.
Highlight the text:
Grades
and
Cut
and
Paste
the text into cell A1.
Cut
and
Paste
the text:
Total
into cell A11.
Now to enter the formula for the total sum of the grades.
Select cell B11 and enter the following formula:
Remeber to click on the
Enter
button or press the Return key to enter the formula.
Your worksheet should look as follows:
Select cell A12 and enter the text:
Average
.
Select cell B12 and enter the following formula:
Your worksheet should look as follows:
Let's annotate (comment) the formula in cell B12.
Next Topic: Annotating Formulas
Main Menu