Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Basic Facts about Formulas
Basic Facts about Formulas
In This Chapter
How to enter, edit, and paste names into formulas
The various operators used in formulas
How Excel calculates formulas
Cell and range references used in formulas
How to make an exact copy of a formula
How to convert formulas to values
How to prevent formulas from being viewed
The types of formula errors
Circular reference messages and correction techniques
Excel’s goal seeking feature
This chapter serves as a basic introduction to using formulas in Excel. Although I direct its focus
on newcomers to Excel, even veteran Excel users may find some new information here.
Entering and Editing Formulas
This section describes the basic elements of a formula. It also explains various ways of entering
and editing your formulas.
A formula entered into a cell can consist of five elements:
h Operators: These include symbols such as + (for addition) and * (for multiplication).
h Cell references: These include named cells and ranges that can refer to cells in the
current worksheet, cells in another worksheet in the same workbook, or even cells in a
worksheet in another workbook.