Microsoft Office Tutorials and References
In Depth Information
Directly Entering Formulas and Functions
3. Add, edit, or delete arguments.
•Toaddanargument(ifthefunctionallows),usetheRefEditcontrol to pick up the extra values from the worksheet. Alternatively,
if you click in the bottom argument reference, a new box opens
below it into which you can enter a value or range.
4. Click OK when you’re finished.
The function is updated with your changes.
Directly Entering Formulas
As you get sharp with functions, you will likely bypass the Insert Function
dialog box altogether and enter functions directly. One place you can do this
is in the Formula Bar. Another way is to just type into a cell.
Entering formulas and functions
in the Formula Bar
When you place your entry in the Formula Bar, the entry is really going into
the active cell. However, since the active cell can be anywhere, you may
prefer entering formulas and functions directly in the Formula Bar. That way
you know that the entry will land where you need it. Prior to entering a
formula in the Formula Box (on the right side of the Formula Bar), the Name Box
on the left lets you know where the entry will end up. The cell receiving the
entry may be not be in the visible area of the worksheet. Gosh, it could be
a million rows down and thousands of columns to the right! After you start
entering the formula, the Name Box becomes a drop-down list of functions.
This is useful for nesting functions. As you enter a function in the Formula
Box, you can click on a function in the Name Box and the function is inserted
into the entry you started in the Formula Box. Confused? Imagine what I went
through explaining that! Seriously though, this is a helpful way to assemble
nested functions. Try it, get used to it; it will add to your Excel smarts.