HP 620Lx HP 620LX/660LX PalmTop - (English) User Guide - Page 90

Arithmetic operators, Comparison operators, First Quarter 1996, Total, sales for &A1, Total - for sale

Get HP 620Lx - Palmtop PC PDF manuals and user guides View all HP 620Lx manuals
Add to My Manuals
Save this manual to your list of manuals

Page 90 highlights

3. Tap the desired function. The result appears in the status bar. In addition to functions, Pocket Excel supports formulas, so that you can calculate values and analyze worksheets. Specifically, you can perform operations on worksheet values by using one of three operators on elements of a formula: • Arithmetic operators, such as addition, subtraction, division, multiplication, percent, and exponentiation, perform basic mathematical operations and produce numeric results. • Comparison operators compare two values and produce the logical value TRUE or FALSE. Examples include Text operators join two or more text values into a single combined text value. For example, if First Quarter 1996 is the text in cell A1, the formula, ="Total sales for "&A1, produces the text, Total Sales for First Quarter 1996. Once you have entered a formula, the formula's resulting value appears in the corresponding cell on the worksheet. When you select a cell containing a formula, the formula always appears in the formula bar. To enter a formula 1. Tap the cell you into which you want to enter the formula. 2. Type an equal sign (=) to activate the formula bar. (A formula must begin with an equal sign.) 3. Enter the formula using the following guidelines: • Use parentheses to enclose ranges (which are part of formulas) and other function arguments. For example, (A1:B3) represents the cell references and (1,2,3) represents constant values in the formula, =AVERAGE(SUM(A1:B3),SUM(1,2,3)). 80 - HP Palmtop PC User Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
80 - HP Palmtop PC User Guide
3. Tap the desired function. The result appears in the status bar.
In addition to functions, Pocket Excel supports formulas, so that you can calcu-
late values and analyze worksheets. Specifically, you can perform operations on
worksheet values by using one of three operators on elements of a formula:
•
Arithmetic operators
, such as addition, subtraction, division, multiplication,
percent, and exponentiation, perform basic mathematical operations and
produce numeric results.
•
Comparison operators
compare two values and produce the logical value
TRUE or FALSE. Examples include =,
>,
< , >= , <=,
< >.
•
Text operators join two or more text values into a single combined text value.
For example, if
First Quarter 1996
is the text in cell A1, the formula,
=”Total
sales for “&A1
, produces the text,
Total Sales for First Quarter 1996
.
Once you have entered a formula, the formula’s resulting value appears in the
corresponding cell on the worksheet. When you select a cell containing a for-
mula, the formula always appears in the formula bar.
To enter a formula
1. Tap the cell you into which you want to enter the formula.
2. Type an equal sign (=) to activate the formula bar. (A formula must begin
with an equal sign.)
3. Enter the formula using the following guidelines:
•
Use parentheses to enclose ranges (which are part of formulas) and other
function arguments. For example, (A1:B3) represents the cell references
and (1,2,3) represents constant values in the formula,
=AVERAGE(SUM(A1:B3),SUM(1,2,3)).