Microsoft Office Tutorials and References
In Depth Information
Directly Entering Formulas and Functions
A1: 15
A2: 32
A7: 38
A8: 39
A9: 28
A10: 26
A11: 29
A12: 30
A13: 30
A14: 28
A15: 31
The formula in D5 is +(A1+A2) * MIN(A7:A15). This results in 1222, not 21.
Excel’s ability to show a list of functions based on spelling is called Formula
AutoComplete.
Figure 2-15:
Completing
the
direct-inthe-cell
formula
entry.
You can turn Formula AutoComplete on or off in the Excel Options dialog box:
1. Click the File tab at the top left of the screen.
2. Click Options.
3.IntheExcelOptionsdialogbox,selecttheFormulastab.
4. In the Working with Formulas section, check or uncheck the Formula
AutoCompletecheckbox.
See Figure 2-16 for the check box’s placement.
5. Click the OK button.
Search JabSto ::




Custom Search