Enter a simple formula
Simple formulas contain operators and constants. Operators are signs or symbols that specify the type
of calculation to perform in an expression. Constants are values that are not calculated and do not
change. For example, the number 210 is a constant.
Here are some example formulas and what they do:
●
=128+345 adds 128 and 345.
●
=5^2 squares 5.
1.
Tap the cell in which you want to enter the formula.
2.
On the on-screen keyboard, tap = (the equal sign).
3.
Enter the formula.
NOTE:
To view additional characters on the on-screen keyboard, tap CAP or Shift.
4.
On the keyboard, press Enter.
Enter a formula that contains a cell reference
A formula can contain a cell reference. This is the location of a cell on a worksheet. For example, cell
B2 is the cell located at the intersection of column B and row 2. A formula that contains a reference to
B2 performs a calculation that is based on the value in cell B2. If the value in B2 changes, the result
calculated by the formula also changes.
Here are some example formulas with cell references and what they do:
●
=B2 uses the value in the cell B2.
●
=B2*C2 multiplies the value in cell B2 by the value in cell C2.
1.
Tap the cell in which you want to enter the formula.
2.
On the on-screen keyboard, tap = (an equal sign).
3.
Enter the formula.
TIP:
To include a cell reference, tap the cell you want to include in the formula. For example, to
multiply the value in cell B2 by the value in cell C2, tap =, tap B2, tap *, and then tap C2. This
will end up looking like this in the selected cell: =B2*C2.
4.
On the keyboard, press Enter.
Enter a formula that contains a function
A formula can contain a function. A function is a prewritten formula that takes a value or values,
performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on
a worksheet, especially those that perform lengthy or complex calculations.
Microsoft® Office Mobile
87
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
173
174
175
176
177
178
179
180
181
182
183
184
185
