- Formula Basics
- Summarizing Data Quickly
- Elements of Formulas
- Entering Formulas
- Determining the Order of Operations
- Understanding Cell References
- Using Cell References
- Understanding Comparison Operators
- Using Comparison Operators
- Understanding Functions
- Using Functions
- Copying and Moving Formulas
- Handling Errors
A simple formula is =1+2. (An even simpler one is =3, but that’s no different than just typing 3 in a cell.) The leading equal sign, supplied for you when you use the formula keyboard, distinguishes a formula from text, numbers, dates, and other raw values.
To enter a formula in a cell:
- Double-tap the cell.
- If you’re entering a new formula, tap on the left side of the formula bar (just above the keyboard) to open the formula keyboard.
If you’re editing an existing formula, the formula keyboard opens automatically.
- Position the insertion point in the formula bar or select an element to change or replace, and then do any of the following
- To insert a constant, type it. For numbers, tap the numeric keys on the formula keyboard. For text, tap the “abc” key. For dates, times, and durations, tap the key. For Boolean values, tap the true/false key (tap it repeatedly to toggle the value).
- To insert an arithmetic operator, tap its key on the left side of the formula keyboard. If the arithmetic operators aren’t visible, tap the ()+÷ key.
- To insert a cell reference, see “Using Cell References” later in this chapter.
- To insert a comparison operator, see “Using Comparison Operators” later in this chapter.
- To insert a function, see “Using Functions” later in this chapter.
- To remove an element, select it or position the insertion point to the right of the element, and then tap . To remove multiple elements, you can tap repeatedly or touch and hold .
- When you’re done, tap to enter the formula, or tap to cancel and revert to the cell’s previous contents.