Casio FX-CG10 User Manual Page 370
- Page / 601
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
9-19
3. Using Special Spreadsheet
Mode Commands
The Spreadsheet
mode has a number of special commands like CellSum(, which returns
the sum of a range of cells, and CellIf(, which specifies branching conditions. These special
commands can be used inside of formulas.
k Special Spreadsheet
Mode Command List
“Input Key Operation” operations can be performed during cell input only.
You can omit anything enclosed in brackets ([ ]) in the Syntax of each command.
Command Description
CellIf(
(Branch Condition)
Returns Expression 1 when the equality or inequality provided as
the branch condition is true, and Expression 2 when it is false.
Input Key Operation: 4(If)
Syntax: CellIf(equality, expression 1, expression 2[)] or
CellIf(inequality, expression 1, expression 2[)]
Example: =CellIf(A1>B1, A1, B1)
Returns the value of A1 when {Cell A1 value} > {Cell B1 value}.
Otherwise, returns the value of B1.
CellMin(
(Cell Minimum Value)
Returns the minimum value in a specified range of cells.
Input Key Operation: 5(CELL) 1(Min)
Syntax: CellMin(start cell:end cell[)]
Example: =CellMin(A3:C5)
Returns the minimum value of the data in cell range A3:C5.
CellMax(
(Cell Maximum Value)
Returns the maximum value in a specified range of cells.
Input Key Operation: 5(CELL) 2(Max)
Syntax: CellMax(start cell:end cell[)]
Example: =CellMax(A3:C5)
Returns the maximum value of the data in cell range A3:C5.
CellMean(
(Mean of Cells)
Returns the mean value in a specified range of cells.
Input Key Operation: 5(CELL) 3(Mean)
Syntax: CellMean(start cell:end cell[)]
Example: =CellMean(A3:C5)
Returns the mean value of the data in cell range A3:C5.
- fx-CG10 1
- Contents 3
- — Read This First! 6
- Basic Operation 8
- 2. Display 10
- ( ) 29
- 5. Option (OPTN) Menu 34
- 7. Program (PRGM) Menu 38
- 8. Using the Setup Screen 39
- 9. Using Screen Capture 43
- Manual Calculations 47
- 1 , etc 52
- 2. Special Functions 53
- = 0 to 9) 58
- 4. Function Calculations 60
- (RanNorm#) 65
- (RanBin#) 66
- (MOD_Exp) 67
- = 0.0009k (kilo) 68
- 5. Numerical Calculations 70
- ' 74
- Positive 77
- part ( 77
- Negative part ( 77
- 'r ∠ 83
- 'a + b i ) w 83
- Calculations with Integers 84
- 16 and AD 16 ” 86
- 8. Matrix Calculations 87
- 1 2 3 88
- 4 5 6 88
- 1 3 5 95
- 2 4 6 95
- Integer of a Matrix 102
- 'a+b i , 'r ∠ 103
- Important! 104
- List Function 108
- 2. Manipulating List Data 114
- 5. Using CSV Files 125
- Equation Calculations 128
- 3. Solve Calculations 131
- Graphing 133
- 'Y=) to 5('Y≤) 135
- 3. Drawing a Graph 145
- min, Tmax, Tptch values) 152
- • AS) 153
- 6. Manual Graphing 157
- 7. Using Tables 162
- 8. Modifying a Graph 168
- Modify Function is Running 171
- 9. Dynamic Graphing 172
- + y − 1 and graph a 181
- Screen (Sketch) 182
- 13. Function Analysis 184
- Integration value 190
- Area value 190
- Statistical Graphs and 194
- Calculations 194
- Statistical Data 201
- 0.1 0.2 0.4 0.7 0.8 0.9 1.0 206
- ) and Mean Square Error (MSe) 217
- 5. Tests 225
- Z Tests 226
- μ 227
- s 231
- • 232
- Test Common Functions 232
- GOF Test ( 232
- one-way Test) 232
- two-way Test 233
- σ 234
- F value 235
- 6. Confidence Interval 239
- Z Interval 240
- 7. Distribution 242
- Distribution 247
- • Inverse 248
- F Distribution 249
- Interval, and Distribution 258
- 9. Statistic Formula 261
- λ 264
- Financial Calculation 265
- 2. Simple Interest 267
- 3. Compound Interest 268
- { } 269
- Important! 270
- NFV = NPV × (1 + i ) 271
- +1 > 0, or 0 272
- 1 = 0 and PRN1 = PMT 274
- 6. Interest Rate Conversion 276
- CST : cost 277
- SEL : selling price 277
- MRG : margin 277
- 8. Day/Date Calculations 278
- Issue date 281
- Redemption date (d2) 281
- (N–1+B/D ) (k–1+B/D ) 282
- Programming 285
- 3. Editing Program Contents 288
- 4. File Management 290
- 5. Command Reference 295
- numeric expression 297
- numeric expression 298
- No parameters 304
- No parameters 304
- =, ≠, >, <, ≥, ≤ 308
- Rows to be swapped 314
- Matrix name 314
- σ 325
- • Student- t Distribution 326
- • Poisson Distribution 328
- • Geometric Distribution 328
- • Z Test 329
- • t Test 330
- • F Test 331
- • ANOVA 331
- • Setup Commands 332
- I %, PV, PMT, P/Y, C/Y) 334
- 7. Program Mode Command List 335
- Level 1Level 2Level 3 Command 336
- (PRGM) key 339
- (SET UP) key 339
- Level 3 Level 4 Command 341
- max"* 343
- max command 343
- Command Text 344
- 9. Program Library 350
- Program Name Ellipse 351
- Spreadsheet 352
- Mode Commands 370
- Mode Command Example 371
- 4. Conditional Formatting 372
- Mode Function Menu 382
- Correspondence Table 382
- 6. Spreadsheet 385
- Mode Memory 385
- eActivity 388
- 2. eActivity Function Menus 389
- Cursor 392
- Text line cursor 393
- Math line cursor 395
- Memo icon 398
- Memo Window 399
- File usage 410
- Memory Manager 411
- System Manager 424
- Data Communication 432
- II or ANSI code txt format 439
- Calculators 441
- Data item name 443
- II does not support color 444
- II to this calculator, for 446
- Geometry 448
- 5. Using the Measurement Box 488
- Measurement Values 498
- 6. Working with Animations 503
- Picture Plot 512
- 3. Using the Plot Function 518
- 4. Using the Plot List 524
- AXTRANS screen 527
- Appendix 530
- • Equation mode errors 532
- • Spreadsheet mode errors 535
- • eActivity mode errors 535
- • Memory mode errors 536
- • Data communication errors 538
- • Geometry mode errors 539
- • Picture Plot mode errors 541
- • Setup errors 541
- • Other errors 542
- 2. Input Ranges 543
- Application 545
- 20100801 546
- 2010080120100801 547
- CASIO COMPUTER CO., LTD 601
Related products and manuals for Calculators, organizers Casio FX-CG10
(411 pages)
(602 pages)
(602 pages)
(128 pages)© 2020, manymanuals.com. All rights reserved. | 1.433 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals