Entering Formulas
If an entry in Excel starts with the equal sign (=), the subsequent string is treated as a calculation formula. You can start a formula with the plus or minus sign, but Excel will always add the equal sign at the beginning of the formula.
A formula consists of operands and operators. The operands are the values for the calculation, and the operators are the rules (see Figure 3-1).
Figure 3-1. Operands and operators are the basic elements of a formula.
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
