Unitech PA960 Technical Information Page 111

  • Download
  • Add to my manuals
  • Print
  • Page
    / 204
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 110
10-111
Refer to a cell or range
1.
Begin entering the formula.
2.
Select the cell or select the range to set the reference.
3.
Finish entering the formula.
4.
Tap ENTER in the input panel.
To refer to a cell in another worksheet, in your formula, enter the
worksheet name followed by an exclamation point (!) and the cell, range,
or name reference.
Example: =Sheet1!Earnings
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)
See Also:
Name a cell or range
Automatically calculate values
1.
Select the range of values you want to calculate. The AutoCalculate area,
on the right side of the status bar, contains a function and value (example:
SUM=0). (If you don't see the status bar, tap
View
>
Status Bar
.)
2.
To display a list of calculation types, tap the AutoCalculate arrow.
3.
From the list, select the calculation type that you want.The result appears in
the AutoCalculate area.
See Also:
Enter a formula
Page view 110
1 2 ... 106 107 108 109 110 111 112 113 114 115 116 ... 203 204

Comments to this Manuals

No comments