This preview shows page 1. Sign up to view the full content.
Unformatted text preview: alculating results.
• If a part of a formula is in parentheses, that part will always
be calculated before the rest of the formula.
o The formula =(B2*C2)-A3 will subtract data in cell
A3 from the multiplied product of cells B2 and C2.
• After expressions in parentheses, Excel will calculate your
formula using the math operators in the following order
• In other words, Excel will begin to parse your formula
starting with any multiplication and division. Once this is
complete, Excel will add and subtract the remainder of
your formula. Inserting a function
Each of Excel’s functions is a predefined formula, and most act on
a range of cells that you select. (Excel refers to each range of cells
in the function as an argument.) Although a few functions do not
use arguments, most have one or more and some complex
functions use as many as 3 or 4 arguments. Excel provides a Paste
Function window to simplify the process of inserting functions
into your worksheets and eliminate the need to remember the...
View Full Document
This document was uploaded on 03/12/2014.
- Spring '14