Apple Numbers '08 Bedienungsanleitung Seite 212
- Seite / 295
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
212 Chapter 12 Dictionary of Functions
CEILING
The CEILING function rounds a number away from zero to the nearest multiple of the
specified factor.
CEILING(number, factor)
 number: A number, numeric expression, or references to a cell containing a numeric
expression.
 factor: The number whose multiples you want to round to. factor must have the
same sign as number.
Notes
To round down (toward zero) instead of up, use the FLOOR function.
Other functions related to rounding numbers: INT, ROUND, ROUNDUP, ROUNDDOWN,
TRUNC.
CHAR
The CHAR function returns the character that corresponds to a numeric Unicode
character code.
CHAR(code-number)
 code-number: A number from 1 through 65535 for which you want to generate the
corresponding character.
Examples
AVERAGEA(A1:A4) returns 2.5 if cells A1 through A4 contain 4, a, 6, b. The text values are counted as
zeros in the sum of 10 and included in the count of values (4). Compare with AVERAGE(A1:A4), which
ignores the text values completely for a sum of 10, a count of 2, and an average of 5.
AVERAGEA(A1:A4) returns 4 if cells A1 through A4 contain 5, a, TRUE, 10. The text value counts zero
and TRUE counts 1 for a sum of 16 and a count of 4.
AVERAGEA(A1:A4) returns 0.25 if cells A1 through A4 contain FALSE, FALSE, FALSE, TRUE. Each FALSE
counts zero and TRUE counts 1 for a sum of 1 and a count of 4.
Examples
CEILING(0.25,1) returns 1.
CEILING(1.25,1) returns 2.
CEILING(-1.25,-1) returns -2.
CEILING(5,2) returns 6.
CEILING(73,10) returns 80.
CEILING(7,2.5) returns 7.5.
- Numbers ’08 1
- User’s Guide 1
- Contents 3
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- Welcome to the 16
- Numbers User’s Guide 16
- Numbers Tools and Techniques 18
- The Numbers Window 20
- Spreadsheet Viewing Aids 21
- Print View 22
- Alignment Guides 22
- The Styles Pane 23
- The Toolbar 24
- The Format Bar 25
- The Inspector Window 25
- Formula Tools 26
- Click to open the 27
- Function Browser 27
- The Media Browser 28
- The Colors Window 28
- The Font Panel 29
- The Warnings Window 29
- Working with a Numbers 31
- Importing a Document 33
- Saving Spreadsheets 34
- Undoing Changes 35
- Viewing Sheets 37
- Adding and Deleting Sheets 38
- Dividing a Sheet into Pages 39
- Using Headers and Footers 41
- Arranging Objects on a Page 41
- Setting Page Orientation 42
- Setting Pagination Order 42
- Numbering Pages 42
- Setting Page Margins 43
- Using Tables 44
- Working with Tables 45
- 46 Chapter 3 Using Tables 46
- Chapter 3 Using Tables 47 47
- Resizing a Table 48
- Moving Tables 48
- Naming Tables 49
- Defining Reusable Tables 49
- 50 Chapter 3 Using Tables 50
- Selecting a Table 51
- Selecting a Table Cell 51
- Selecting a Row or Column 52
- Selecting Table Cell Borders 53
- 54 Chapter 3 Using Tables 54
- Working with Text in Cells 55
- Working with Numbers in Cells 56
- Working with Dates in Cells 57
- Formatting Cell Values 58
- Chapter 3 Using Tables 59 59
- 60 Chapter 3 Using Tables 60
- Chapter 3 Using Tables 61 61
- 62 Chapter 3 Using Tables 62
- Chapter 3 Using Tables 63 63
- 64 Chapter 3 Using Tables 64
- Chapter 3 Using Tables 65 65
- 66 Chapter 3 Using Tables 66
- Monitoring Cell Values 67
- Autofilling Table Cells 68
- Working with Rows and Columns 69
- Adding Columns 70
- Rearranging Rows and Columns 70
- Chapter 3 Using Tables 71 71
- Using a Footer Row 72
- Hiding Rows and Columns 72
- Alternating Row Colors 73
- Working with Table Cells 74
- Formatting Table Cell Borders 75
- Copying and Moving Cells 76
- Adding Comments 76
- Reorganizing Tables 77
- Filtering Rows 78
- Working with Table Styles 79
- Applying Table Styles 80
- Modifying a Table’s Style 80
- Using the Default Table Style 81
- Creating New Table Styles 82
- Renaming a Table Style 82
- Deleting a Table Style 82
- Using Formulas 83
- A Tour of Using Formulas 84
- Adding a Quick Formula 87
- Removing a Formula 88
- Using the Formula Editor 88
- Using the Formula Bar 90
- Using Cell References 91
- Handling Errors and Warnings 93
- Using Operators 94
- Using Functions 96
- Using Charts 98
- Chapter 6 Using Charts 99 99
- Adding a Chart 101
- Editing Charts 102
- Chapter 6 Using Charts 103 103
- Deleting a Chart 105
- Moving a Chart 105
- Using a Legend 106
- Using a Chart Title 107
- Resizing a Chart 107
- Rotating Charts 107
- Chapter 6 Using Charts 109 109
- Chapter 6 Using Charts 111 111
- Pie Charts 113
- Set a pie wedge apart by 114
- Bar and Column Charts 115
- Area Charts and Line Charts 116
- Scatter Charts 117
- 3D Charts 118
- Working with Text 119
- Selecting Text 120
- Smart quotes 128
- Straight quotes 128
- Adjusting Font Smoothing 129
- Aligning Text Horizontally 131
- Aligning Text Vertically 131
- Changing Text Color 133
- Setting a New Tab Stop 135
- Changing a Tab Stop 135
- Deleting a Tab Stop 135
- Setting Indents 136
- Setting Indents for Lists 137
- Using Bulleted Lists 138
- Using Numbered Lists 139
- Adding Text Boxes 141
- Presenting Text in Columns 141
- Putting Text Inside a Shape 142
- Using Hyperlinks 143
- Editing Hyperlink Text 144
- Inserting a Nonbreaking Space 146
- Finding and Replacing Text 148
- Selecting Objects 149
- Deleting Objects 150
- Moving Objects 150
- Aligning Objects 151
- Modifying Objects 154
- Changing the Style of Borders 155
- Framing Objects 156
- Adding Shadows 156
- Adding a Reflection 158
- Adjusting Opacity 158
- Grouping and Locking Objects 159
- Filling Objects 160
- Using the Colors Window 161
- Using Shapes 164
- Making Shapes Editable 165
- Reshaping a Curve 166
- Reshaping a Straight Segment 167
- Using Media Placeholders 170
- Working with Images 171
- Masking (Cropping) Images 172
- Using PDF Files as Graphics 176
- Using Sound and Movies 177
- Adding Address Book Data 179
- Sharing Your Numbers 183
- Spreadsheet 183
- The ColorSync Utility icon 186
- Sending a Spreadsheet to iWeb 187
- Designing Your Own Numbers 188
- Spreadsheet Templates 188
- Dictionary of Functions 193
- Date and Time Functions 195
- Financial Functions 196
- Logical Functions 198
- Information Functions 198
- Reference Functions 199
- Numeric Functions 200
- Trigonometric Functions 201
- Statistical Functions 202
- Text Functions 204
- Function Descriptions 205
- ACCRINTM 206
- AVERAGEA 211
- CONCATENATE 216
- CONFIDENCE 216
- COUNTBLANK 220
- COUPDAYBS 221
- COUPDAYS 221
- COUPDAYSNC 222
- FORECAST 233
- HYPERLINK 236
- INDIRECT 237
- INTERCEPT 238
- Examples 253
- PERCENTILE 256
- PRICEDISC 260
- PRICEMAT 260
- QUOTIENT 263
- RANDBETWEEN 264
- ROUNDDOWN 268
- SUBSTITUTE 277
- SUMPRODUCT 278
- TIMEVALUE 282
- Index 291 291
- 292 Index 292
- Index 293 293
- 294 Index 294
- Index 295 295
Verwandte Produkte und Handbücher für Software Apple Numbers '08
Software Apple MainStage 3 Bedienungsanleitung
(34 Seiten)
(34 Seiten)
Software Apple iPhoto '08 Bedienungsanleitung
(22 Seiten)
(22 Seiten)
Software Apple Numbers '09 Bedienungsanleitung
(288 Seiten)
(288 Seiten)
Software Apple QuickTime 7.2 Bedienungsanleitung
(73 Seiten)
(73 Seiten)
Software Apple Keynote 1 Bedienungsanleitung
(100 Seiten)
(100 Seiten)
Software Apple Xsan 2 Bedienungsanleitung
(165 Seiten)
(165 Seiten)
Software Apple Logic Pro 9 Bedienungsanleitung
(357 Seiten)
(357 Seiten)
Software Apple Numbers '09 Bedienungsanleitung
(270 Seiten)
(270 Seiten)
Software Apple MainStage Bedienungsanleitung
(100 Seiten)
(100 Seiten)
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.067 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern