␡

- 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

This chapter is from the book

## Entering Formulas

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.
*or*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 .

- To insert a constant, type it. For numbers, tap the numeric keys on the formula keyboard. For text, tap the
- When you’re done, tap to enter the formula, or tap to cancel and revert to the cell’s previous contents.