Palm PMG0501000P manual Entering a formula, Inserting a function

Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S

11

Entering a formula

1Highlight the cell where you want to enter the formula.

2Enter an equals sign ( = ) followed by any values, cell references, name references, operators, and functions.

Examples:

•=(B4/25)+100

•=Revenue-Expenses

3Press Return .

TIP Use the Alt key to insert an equal sign.

TIP To insert a symbol, place the cursor where you want the symbol. Press Menu (right softkey) and select Insert > Symbol. Highlight the symbol you want to insert, and select Insert.

4Finish entering the formula and press OK .

TIP To refer to a cell from another worksheet in your formula, enter the worksheet name followed by an exclamation point (!) and the cell, range, or name reference.

Example: =Sheet1!Earnings

TIP To create a 3-D reference in your formula, specify two or more sheets in a workbook. Use a colon between the first and last worksheet names.

Example: =SUM(Sheet2:Sheet6!$A$2:$C$5)

Inserting a function

1Open the workbook where you want to insert the function.

2Press Menu (right softkey) and select Insert > Function.

C H A P T E R

Referring to a cell or range in a formula

1Open the workbook where you want to refer to a cell or range in a formula.

2Begin entering a formula in a cell.

3Navigate to the cell you want to refer to in the formula. To refer to a range, tap and drag the stylus over the cells you want to include in the range.

E X C E L M O B I L E ® 251