|
Introduction
Payment
Function
Using
the If Statement
Scenario
Summary
Sorting
Custom Lists
Recording
Macros
|
|
Using
Formulas
Formulas and function are mathematical statements used to
perform calculations.
-
A formula is an instruction made up by the user to perform
a specific calculation.
- All
formulas must start with an equal sign and contain cell
addresses, numbers, and mathematical operators.
- When
preparing a formula it is important to consider the order
of mathematical operations. A formula that has more than
one operation follows an order of precedence.
The order is as follows from left to right:
1.
Exponentiation
2. Multiplication
3. Division
4. Addition
5. Subtraction
Note:
if a formula has parenthesis, the operation (s) in the parenthesis
is performed first. Remember back the reference Please
Excuse My Dear Aunt
Sally.
| EXAMPLES |
|
|
|
| Operator |
Meaning
|
Example
|
Result (if A1=18 & A2=2)
|
|
+
|
Addition |
=A1+A2 |
20
|
|
-
|
Subtraction |
=A1-A2 |
16
|
|
*
|
Multiplication |
=A1*A2 |
36
|
|
/
|
Division |
=A1/A2 |
9
|
|
%
|
Percentage |
=A1% |
.18
|
|
^
|
Exponentiation |
=A1^A2 |
324
|
Excercise
1
The
following 2 exercises are intended as a refresher for those
users who do not use Excel that often. If you are an experienced
user advance to Excercise 3.
- Create
the worksheet listed shown on the next page. The sale tax
is approximately is 6% entered as .06.
- Enter
the labels and values in the exact cell locations shown
in the spreadsheet.
- Enter
the formulas, as shown in the shaded cells. Tap the Enter
key after each formula.
- Copy
the formula to the respective cells by using the fill handle
and drag downward.
- Format
the cells using the currency format with the dollar sign.
| |
A
|
B
|
C
|
D
|
E
|
F
|
G
|
| 1 |
Merchandise |
|
List
Price |
Discount |
Sales
Price |
Sales
Tax |
Total
Price |
| 2 |
|
|
|
|
|
|
|
| 3 |
Printer |
|
345
|
185
|
=C3-D3
|
=E3*.06
|
=E3+F3
|
| 4 |
Computer |
|
985
|
265
|
|
|
|
| 5 |
Monitor |
|
395
|
98
|
|
|
|
Exercise
2
- Select
the entire formula sheet and paste it into sheet2.
- Enter
the new labels in column A.
A8 - Totals
A9 - Average
A10 - Count
A11 - Maximum
A12 - Minimum
- Click
on the Edit Formula (= sign) in the cell related to the
label.
- Use
the drop down arrow in the Function box to locate the function.
Next select the cells under the label Total Price for the
proper argument.
|
|
