Microsoft Office Tutorials and References
In Depth Information
Adding Functions to a Formula
The mixed reference $B7 tells Excel that no matter where you copy the formula, it should
always point to the value in column B for the current row. To create a mixed range, type
it manually or select the reference and then press F4 multiple times to cycle through each
available option.
Controlling the Order of Calculation in a Formula
The order in which Excel performs operations in formulas makes a difference. It’s common
for formulas to contain multiple operators. Unless you specify a custom order by using
parentheses, Excel performs calculations in the following order:
% (percent)
^ (exponentiation)
* and / (multiplication and division)
+ and – (addition and subtraction)
& (concatenation)
=, < and >, <= and >, =, and <> (comparison)
When the same operator is used multiple times in a formula, the calculations are performed
in order from left to right.
When you use functions as arguments within functions, you use multiple sets of
parentheses to keep things separate. You can nest functions to as many as 64 levels within a formula.
Adding Functions to a Formula
Excel savants who’ve memorized the syntax of the functions they use regularly can enter
a formula as fast as they can type. Start with an equal sign, spell each function name
correctly, separate arguments with commas, and make sure every opening parenthesis is
matched with a closing parenthesis. As long as you get all those details right, you’ll have no
problems.
Search JabSto ::




Custom Search