Spreadsheet 169
Using Advanced Spreadsheet Formulas
This section describes how to create formulas and use functions to make
complex formulas easy. This section explains how to do the following:
S
Show andhide formulas
S
Assign names to cells andranges so you can use the names in formulas
S
Turn automatic recalculation on andoff
S
Use circular references anditeration in calculations
S
Use advanced functions
Showing and Hiding Formulas
In order to see a formula for a single cell, you can select the cell and look
at the formula in the Edit Bar. If you want, you can display all of the
formulas in the spreadsheet cells. This can be helpful if you have entered
several formulas andwant to see them all at once.
When you show all formulas, formulas appear in cells as if they were
labels. That is, if a formula is too long for a cell, it may spill over into the
next cell if that cell is empty. If the adjacent cell is not empty, the formula
appears cut off.
"
To show or hide all formulas:
1. Select Other Settings from the Options menu.
2. Select Show Formulas to show all formulas.
Deselect Show Formulas to hide all formulas.
Naming Cells and Ranges
When you create a formula, you normally include references to the cells
andranges you want to use in the calculation. While you can refer to cells
and ranges by their addresses, you can also name a cell or a range and
then use the name in formulas. This can make your formulas easier to
read. The second formula in the following example is much easier to
understand than the first.
B4=B2+B3
or
INCOME=TIPS
Cell names can be up to 40 characters long andcan include alphanumeric
characters andthe underscore (_) symbol. Cell names cannot contain
numbers, spaces, or other characters. If you type a space, Spreadsheet
inserts an underscore. Cells names are case insensitive; for example, to
Spreadsheet, the name Expenses" is the same as EXPENSES" and
expenses."
This section assumes you are
familiar with the information
covered in Getting Started.
An absolute reference
tells
Spreadsheet the specific address
of a cell.
A relative reference
tells
Spreadsheet how to find a
particular cell starting from the
cell containing the formula, such
as: “go two rows up and one
column to the right.”
Summary of Contents for Ensemble PDP-100J
Page 11: ......
Page 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Page 72: ......
Page 83: ......
Page 152: ......
Page 217: ...Spreadsheet 203 The following dialog box appears ...
Page 219: ......
Page 262: ......
Page 269: ......
Page 284: ......
Page 301: ......
Page 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Page 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Page 312: ......
Page 325: ......
Page 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Page 330: ......
Page 333: ......
Page 337: ...Text File Editor 314 ...
Page 338: ......
Page 345: ......
Page 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Page 350: ......
Page 379: ......
Page 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Page 396: ...Appendix 369 Print Functions Function Description Example ...
Page 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Page 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Page 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Page 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Page 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Page 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Page 414: ......
Page 418: ...Glossary 390 ...
Page 420: ...Glossary 392 0 1 1 1 ...
Page 421: ...Glossary 393 text style sheet ...
Page 422: ...Glossary 394 ...
Page 423: ......
Page 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Page 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Page 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Page 440: ......