{"id":352711,"date":"2024-10-20T00:54:01","date_gmt":"2024-10-20T00:54:01","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-26300-22015\/"},"modified":"2024-10-26T00:56:08","modified_gmt":"2024-10-26T00:56:08","slug":"bs-iso-iec-26300-22015","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-26300-22015\/","title":{"rendered":"BS ISO\/IEC 26300-2:2015"},"content":{"rendered":"
PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
---|---|---|---|---|---|---|---|
24<\/td>\n | Blank Page <\/td>\n<\/tr>\n | ||||||
25<\/td>\n | 1 Introduction 1.1 Introduction 1.2 Terminology 1.3 Purpose 1.4 Normative References <\/td>\n<\/tr>\n | ||||||
26<\/td>\n | 1.5 Non-Normative References <\/td>\n<\/tr>\n | ||||||
27<\/td>\n | 2 Expressions and Evaluators 2.1 Introduction 2.2 OpenDocument Formula Expression 2.3 Evaluators 2.3.1 OpenDocument Formula Evaluator 2.3.2 OpenDocument Formula Small Group Evaluator <\/td>\n<\/tr>\n | ||||||
28<\/td>\n | 2.3.3 OpenDocument Formula Medium Group Evaluator <\/td>\n<\/tr>\n | ||||||
29<\/td>\n | 2.3.4 OpenDocument Formula Large Group Evaluator <\/td>\n<\/tr>\n | ||||||
30<\/td>\n | 2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes) <\/td>\n<\/tr>\n | ||||||
31<\/td>\n | 3 Formula Processing Model 3.1 General 3.2 Expression Evaluation 3.2.1 General 3.2.2 Expression Calculation 3.2.3 Operator and Function Evaluation <\/td>\n<\/tr>\n | ||||||
32<\/td>\n | 3.3 Non-Scalar Evaluation (aka ‘Array expressions’) <\/td>\n<\/tr>\n | ||||||
34<\/td>\n | 3.4 Host-Defined Behaviors <\/td>\n<\/tr>\n | ||||||
35<\/td>\n | 3.5 When recalculation occurs 3.6 Numerical Models 3.7 Basic Limits <\/td>\n<\/tr>\n | ||||||
37<\/td>\n | 4 Types 4.1 General 4.2 Text (String) 4.3 Number 4.3.1 General <\/td>\n<\/tr>\n | ||||||
38<\/td>\n | 4.3.2 Time 4.3.3 Date 4.3.4 DateTime 4.3.5 Percentage 4.3.6 Currency 4.3.7 Logical (Number) <\/td>\n<\/tr>\n | ||||||
39<\/td>\n | 4.4 Complex Number 4.5 Logical (Boolean) 4.6 Error <\/td>\n<\/tr>\n | ||||||
40<\/td>\n | 4.7 Empty Cell 4.8 Reference 4.9 ReferenceList 4.10 Array <\/td>\n<\/tr>\n | ||||||
41<\/td>\n | 4.11 Pseudotypes 4.11.1 General 4.11.2 Scalar 4.11.3 DateParam 4.11.4 TimeParam 4.11.5 Integer 4.11.6 TextOrNumber 4.11.7 Basis 4.11.7.1 General <\/td>\n<\/tr>\n | ||||||
42<\/td>\n | 4.11.7.2 Procedural Notation 4.11.7.3 Procedure A 4.11.7.4 Procedure B <\/td>\n<\/tr>\n | ||||||
43<\/td>\n | 4.11.7.5 Procedure C 4.11.7.6 Procedure D 4.11.7.7 Procedure E 4.11.7.8 Procedure F 4.11.8 Criterion <\/td>\n<\/tr>\n | ||||||
44<\/td>\n | 4.11.9 Database 4.11.10 Field 4.11.11 Criteria <\/td>\n<\/tr>\n | ||||||
45<\/td>\n | 4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence) 4.11.13 Any <\/td>\n<\/tr>\n | ||||||
46<\/td>\n | 5 Expression Syntax 5.1 General 5.2 Basic Expressions <\/td>\n<\/tr>\n | ||||||
47<\/td>\n | 5.3 Constant Numbers 5.4 Constant Strings 5.5 Operators <\/td>\n<\/tr>\n | ||||||
48<\/td>\n | 5.6 Functions and Function Parameters <\/td>\n<\/tr>\n | ||||||
49<\/td>\n | 5.7 Nonstandard Function Names 5.8 References <\/td>\n<\/tr>\n | ||||||
50<\/td>\n | 5.9 Reference List 5.10 Quoted Label 5.10.1 General <\/td>\n<\/tr>\n | ||||||
51<\/td>\n | 5.10.2 Lookup of Defined Labels 5.10.3 Automatic Lookup of Labels <\/td>\n<\/tr>\n | ||||||
52<\/td>\n | 5.10.4 Implicit Intersection 5.10.5 Automatic Range <\/td>\n<\/tr>\n | ||||||
53<\/td>\n | 5.10.6 Automatic Intersection 5.11 Named Expressions <\/td>\n<\/tr>\n | ||||||
54<\/td>\n | 5.12 Constant Errors <\/td>\n<\/tr>\n | ||||||
55<\/td>\n | 5.13 Inline Arrays 5.14 Whitespace <\/td>\n<\/tr>\n | ||||||
56<\/td>\n | 6 Standard Operators and Functions 6.1 General 6.2 Common Template for Functions and Operators <\/td>\n<\/tr>\n | ||||||
57<\/td>\n | 6.3 Implicit Conversion Operators 6.3.1 General 6.3.2 Conversion to Scalar 6.3.3 Implied intersection 6.3.4 Force to array context (ForceArray) <\/td>\n<\/tr>\n | ||||||
58<\/td>\n | 6.3.5 Conversion to Number 6.3.6 Conversion to Integer 6.3.7 Conversion to NumberSequence <\/td>\n<\/tr>\n | ||||||
59<\/td>\n | 6.3.8 Conversion to NumberSequenceList 6.3.9 Conversion to DateSequence 6.3.10 Conversion to Complex Number 6.3.11 Conversion to ComplexSequence <\/td>\n<\/tr>\n | ||||||
60<\/td>\n | 6.3.12 Conversion to Logical 6.3.13 Conversion to LogicalSequence 6.3.14 Conversion to Text 6.3.15 Conversion to DateParam 6.3.16 Conversion to TimeParam <\/td>\n<\/tr>\n | ||||||
61<\/td>\n | 6.4 Standard Operators 6.4.1 General 6.4.2 Infix Operator “+” 6.4.3 Infix Operator “-” 6.4.4 Infix Operator “*” <\/td>\n<\/tr>\n | ||||||
62<\/td>\n | 6.4.5 Infix Operator “\/” 6.4.6 Infix Operator “^” 6.4.7 Infix Operator “=” 6.4.8 Infix Operator “” <\/td>\n<\/tr>\n | ||||||
63<\/td>\n | 6.4.9 Infix Operator Ordered Comparison (“<", "”, “>=”) 6.4.10 Infix Operator “&” 6.4.11 Infix Operator Reference Range (“:”) <\/td>\n<\/tr>\n | ||||||
64<\/td>\n | 6.4.12 Infix Operator Reference Intersection (“!”) 6.4.13 Infix Operator Reference Concatenation (“~”) (aka Union) <\/td>\n<\/tr>\n | ||||||
65<\/td>\n | 6.4.14 Postfix Operator “%” 6.4.15 Prefix Operator “+” 6.4.16 Prefix Operator “-” <\/td>\n<\/tr>\n | ||||||
66<\/td>\n | 6.5 Matrix Functions 6.5.1 General 6.5.2 MDETERM 6.5.3 MINVERSE <\/td>\n<\/tr>\n | ||||||
67<\/td>\n | 6.5.4 MMULT 6.5.5 MUNIT 6.5.6 TRANSPOSE <\/td>\n<\/tr>\n | ||||||
68<\/td>\n | 6.6 Bit operation functions 6.6.1 General 6.6.2 BITAND 6.6.3 BITLSHIFT 6.6.4 BITOR <\/td>\n<\/tr>\n | ||||||
69<\/td>\n | 6.6.5 BITRSHIFT 6.6.6 BITXOR 6.7 Byte-position text functions 6.7.1 General 6.7.2 FINDB <\/td>\n<\/tr>\n | ||||||
70<\/td>\n | 6.7.3 LEFTB 6.7.4 LENB 6.7.5 MIDB 6.7.6 REPLACEB <\/td>\n<\/tr>\n | ||||||
71<\/td>\n | 6.7.7 RIGHTB 6.7.8 SEARCHB 6.8 Complex Number Functions 6.8.1 General 6.8.2 COMPLEX 6.8.3 IMABS <\/td>\n<\/tr>\n | ||||||
72<\/td>\n | 6.8.4 IMAGINARY 6.8.5 IMARGUMENT 6.8.6 IMCONJUGATE 6.8.7 IMCOS <\/td>\n<\/tr>\n | ||||||
73<\/td>\n | 6.8.8 IMCOSH 6.8.9 IMCOT 6.8.10 IMCSC 6.8.11 IMCSCH <\/td>\n<\/tr>\n | ||||||
74<\/td>\n | 6.8.12 IMDIV 6.8.13 IMEXP 6.8.14 IMLN 6.8.15 IMLOG10 <\/td>\n<\/tr>\n | ||||||
75<\/td>\n | 6.8.16 IMLOG2 6.8.17 IMPOWER 6.8.18 IMPRODUCT 6.8.19 IMREAL <\/td>\n<\/tr>\n | ||||||
76<\/td>\n | 6.8.20 IMSIN 6.8.21 IMSINH 6.8.22 IMSEC 6.8.23 IMSECH <\/td>\n<\/tr>\n | ||||||
77<\/td>\n | 6.8.24 IMSQRT 6.8.25 IMSUB 6.8.26 IMSUM 6.8.27 IMTAN <\/td>\n<\/tr>\n | ||||||
78<\/td>\n | 6.9 Database Functions 6.9.1 General 6.9.2 DAVERAGE 6.9.3 DCOUNT 6.9.4 DCOUNTA <\/td>\n<\/tr>\n | ||||||
79<\/td>\n | 6.9.5 DGET 6.9.6 DMAX 6.9.7 DMIN 6.9.8 DPRODUCT <\/td>\n<\/tr>\n | ||||||
80<\/td>\n | 6.9.9 DSTDEV 6.9.10 DSTDEVP 6.9.11 DSUM 6.9.12 DVAR <\/td>\n<\/tr>\n | ||||||
81<\/td>\n | 6.9.13 DVARP 6.10 Date and Time Functions 6.10.1 General 6.10.2 DATE 6.10.3 DATEDIF <\/td>\n<\/tr>\n | ||||||
82<\/td>\n | 6.10.4 DATEVALUE 6.10.5 DAY 6.10.6 DAYS <\/td>\n<\/tr>\n | ||||||
83<\/td>\n | 6.10.7 DAYS360 6.10.8 EDATE <\/td>\n<\/tr>\n | ||||||
84<\/td>\n | 6.10.9 EOMONTH 6.10.10 HOUR 6.10.11 ISOWEEKNUM <\/td>\n<\/tr>\n | ||||||
85<\/td>\n | 6.10.12 MINUTE 6.10.13 MONTH 6.10.14 NETWORKDAYS <\/td>\n<\/tr>\n | ||||||
86<\/td>\n | 6.10.15 NOW 6.10.16 SECOND 6.10.17 TIME <\/td>\n<\/tr>\n | ||||||
87<\/td>\n | 6.10.18 TIMEVALUE 6.10.19 TODAY 6.10.20 WEEKDAY <\/td>\n<\/tr>\n | ||||||
88<\/td>\n | 6.10.21 WEEKNUM 6.10.22 WORKDAY <\/td>\n<\/tr>\n | ||||||
89<\/td>\n | 6.10.23 YEAR 6.10.24 YEARFRAC <\/td>\n<\/tr>\n | ||||||
90<\/td>\n | 6.11 External Access Functions 6.11.1 General 6.11.2 DDE 6.11.3 HYPERLINK <\/td>\n<\/tr>\n | ||||||
91<\/td>\n | 6.12 Financial Functions 6.12.1 General 6.12.2 ACCRINT <\/td>\n<\/tr>\n | ||||||
92<\/td>\n | 6.12.3 ACCRINTM 6.12.4 AMORLINC <\/td>\n<\/tr>\n | ||||||
93<\/td>\n | 6.12.5 COUPDAYBS 6.12.6 COUPDAYS <\/td>\n<\/tr>\n | ||||||
94<\/td>\n | 6.12.7 COUPDAYSNC 6.12.8 COUPNCD <\/td>\n<\/tr>\n | ||||||
95<\/td>\n | 6.12.9 COUPNUM <\/td>\n<\/tr>\n | ||||||
96<\/td>\n | 6.12.10 COUPPCD 6.12.11 CUMIPMT <\/td>\n<\/tr>\n | ||||||
97<\/td>\n | 6.12.12 CUMPRINC 6.12.13 DB <\/td>\n<\/tr>\n | ||||||
98<\/td>\n | 6.12.14 DDB <\/td>\n<\/tr>\n | ||||||
100<\/td>\n | 6.12.15 DISC 6.12.16 DOLLARDE 6.12.17 DOLLARFR <\/td>\n<\/tr>\n | ||||||
101<\/td>\n | 6.12.18 DURATION 6.12.19 EFFECT <\/td>\n<\/tr>\n | ||||||
102<\/td>\n | 6.12.20 FV 6.12.21 FVSCHEDULE 6.12.22 INTRATE <\/td>\n<\/tr>\n | ||||||
103<\/td>\n | 6.12.23 IPMT 6.12.24 IRR <\/td>\n<\/tr>\n | ||||||
104<\/td>\n | 6.12.25 ISPMT 6.12.26 MDURATION <\/td>\n<\/tr>\n | ||||||
105<\/td>\n | 6.12.27 MIRR 6.12.28 NOMINAL <\/td>\n<\/tr>\n | ||||||
106<\/td>\n | 6.12.29 NPER 6.12.30 NPV <\/td>\n<\/tr>\n | ||||||
107<\/td>\n | 6.12.31 ODDFPRICE 6.12.32 ODDFYIELD <\/td>\n<\/tr>\n | ||||||
108<\/td>\n | 6.12.33 ODDLPRICE 6.12.34 ODDLYIELD <\/td>\n<\/tr>\n | ||||||
109<\/td>\n | 6.12.35 PDURATION 6.12.36 PMT <\/td>\n<\/tr>\n | ||||||
110<\/td>\n | 6.12.37 PPMT 6.12.38 PRICE <\/td>\n<\/tr>\n | ||||||
111<\/td>\n | 6.12.39 PRICEDISC 6.12.40 PRICEMAT <\/td>\n<\/tr>\n | ||||||
112<\/td>\n | 6.12.41 PV 6.12.42 RATE <\/td>\n<\/tr>\n | ||||||
113<\/td>\n | 6.12.43 RECEIVED <\/td>\n<\/tr>\n | ||||||
114<\/td>\n | 6.12.44 RRI 6.12.45 SLN 6.12.46 SYD <\/td>\n<\/tr>\n | ||||||
115<\/td>\n | 6.12.47 TBILLEQ 6.12.48 TBILLPRICE <\/td>\n<\/tr>\n | ||||||
116<\/td>\n | 6.12.49 TBILLYIELD 6.12.50 VDB <\/td>\n<\/tr>\n | ||||||
117<\/td>\n | 6.12.51 XIRR 6.12.52 XNPV <\/td>\n<\/tr>\n | ||||||
118<\/td>\n | 6.12.53 YIELD 6.12.54 YIELDDISC <\/td>\n<\/tr>\n | ||||||
119<\/td>\n | 6.12.55 YIELDMAT 6.13 Information Functions 6.13.1 General 6.13.2 AREAS <\/td>\n<\/tr>\n | ||||||
120<\/td>\n | 6.13.3 CELL <\/td>\n<\/tr>\n | ||||||
121<\/td>\n | 6.13.4 COLUMN <\/td>\n<\/tr>\n | ||||||
122<\/td>\n | 6.13.5 COLUMNS 6.13.6 COUNT 6.13.7 COUNTA <\/td>\n<\/tr>\n | ||||||
123<\/td>\n | 6.13.8 COUNTBLANK 6.13.9 COUNTIF 6.13.10 COUNTIFS <\/td>\n<\/tr>\n | ||||||
124<\/td>\n | 6.13.11 ERROR.TYPE 6.13.12 FORMULA 6.13.13 INFO <\/td>\n<\/tr>\n | ||||||
125<\/td>\n | 6.13.14 ISBLANK <\/td>\n<\/tr>\n | ||||||
126<\/td>\n | 6.13.15 ISERR 6.13.16 ISERROR 6.13.17 ISEVEN 6.13.18 ISFORMULA <\/td>\n<\/tr>\n | ||||||
127<\/td>\n | 6.13.19 ISLOGICAL 6.13.20 ISNA 6.13.21 ISNONTEXT <\/td>\n<\/tr>\n | ||||||
128<\/td>\n | 6.13.22 ISNUMBER 6.13.23 ISODD 6.13.24 ISREF 6.13.25 ISTEXT <\/td>\n<\/tr>\n | ||||||
129<\/td>\n | 6.13.26 N 6.13.27 NA 6.13.28 NUMBERVALUE <\/td>\n<\/tr>\n | ||||||
130<\/td>\n | 6.13.29 ROW 6.13.30 ROWS 6.13.31 SHEET <\/td>\n<\/tr>\n | ||||||
131<\/td>\n | 6.13.32 SHEETS 6.13.33 TYPE <\/td>\n<\/tr>\n | ||||||
132<\/td>\n | 6.13.34 VALUE <\/td>\n<\/tr>\n | ||||||
133<\/td>\n | 6.14 Lookup Functions 6.14.1 General 6.14.2 ADDRESS <\/td>\n<\/tr>\n | ||||||
134<\/td>\n | 6.14.3 CHOOSE 6.14.4 GETPIVOTDATA <\/td>\n<\/tr>\n | ||||||
135<\/td>\n | 6.14.5 HLOOKUP <\/td>\n<\/tr>\n | ||||||
136<\/td>\n | 6.14.6 INDEX 6.14.7 INDIRECT <\/td>\n<\/tr>\n | ||||||
137<\/td>\n | 6.14.8 LOOKUP <\/td>\n<\/tr>\n | ||||||
138<\/td>\n | 6.14.9 MATCH <\/td>\n<\/tr>\n | ||||||
139<\/td>\n | 6.14.10 MULTIPLE.OPERATIONS <\/td>\n<\/tr>\n | ||||||
140<\/td>\n | 6.14.11 OFFSET <\/td>\n<\/tr>\n | ||||||
141<\/td>\n | 6.14.12 VLOOKUP 6.15 Logical Functions 6.15.1 General <\/td>\n<\/tr>\n | ||||||
142<\/td>\n | 6.15.2 AND 6.15.3 FALSE 6.15.4 IF 6.15.5 IFERROR <\/td>\n<\/tr>\n | ||||||
143<\/td>\n | 6.15.6 IFNA 6.15.7 NOT 6.15.8 OR <\/td>\n<\/tr>\n | ||||||
144<\/td>\n | 6.15.9 TRUE 6.15.10 XOR 6.16 Mathematical Functions 6.16.1 General 6.16.2 ABS <\/td>\n<\/tr>\n | ||||||
145<\/td>\n | 6.16.3 ACOS 6.16.4 ACOSH 6.16.5 ACOT 6.16.6 ACOTH <\/td>\n<\/tr>\n | ||||||
146<\/td>\n | 6.16.7 ASIN 6.16.8 ASINH 6.16.9 ATAN <\/td>\n<\/tr>\n | ||||||
147<\/td>\n | 6.16.10 ATAN2 6.16.11 ATANH 6.16.12 BESSELI <\/td>\n<\/tr>\n | ||||||
148<\/td>\n | 6.16.13 BESSELJ 6.16.14 BESSELK 6.16.15 BESSELY 6.16.16 COMBIN <\/td>\n<\/tr>\n | ||||||
149<\/td>\n | 6.16.17 COMBINA 6.16.18 CONVERT <\/td>\n<\/tr>\n | ||||||
157<\/td>\n | 6.16.19 COS 6.16.20 COSH <\/td>\n<\/tr>\n | ||||||
158<\/td>\n | 6.16.21 COT 6.16.22 COTH 6.16.23 CSC <\/td>\n<\/tr>\n | ||||||
159<\/td>\n | 6.16.24 CSCH 6.16.25 DEGREES 6.16.26 DELTA 6.16.27 ERF <\/td>\n<\/tr>\n | ||||||
160<\/td>\n | 6.16.28 ERFC 6.16.29 EUROCONVERT <\/td>\n<\/tr>\n | ||||||
161<\/td>\n | 6.16.30 EVEN <\/td>\n<\/tr>\n | ||||||
162<\/td>\n | 6.16.31 EXP 6.16.32 FACT 6.16.33 FACTDOUBLE 6.16.34 GAMMA <\/td>\n<\/tr>\n | ||||||
163<\/td>\n | 6.16.35 GAMMALN 6.16.36 GCD 6.16.37 GESTEP <\/td>\n<\/tr>\n | ||||||
164<\/td>\n | 6.16.38 LCM 6.16.39 LN 6.16.40 LOG 6.16.41 LOG10 <\/td>\n<\/tr>\n | ||||||
165<\/td>\n | 6.16.42 MOD 6.16.43 MULTINOMIAL 6.16.44 ODD 6.16.45 PI <\/td>\n<\/tr>\n | ||||||
166<\/td>\n | 6.16.46 POWER 6.16.47 PRODUCT 6.16.48 QUOTIENT 6.16.49 RADIANS <\/td>\n<\/tr>\n | ||||||
167<\/td>\n | 6.16.50 RAND 6.16.51 RANDBETWEEN 6.16.52 SEC 6.16.53 SERIESSUM <\/td>\n<\/tr>\n | ||||||
168<\/td>\n | 6.16.54 SIGN 6.16.55 SIN <\/td>\n<\/tr>\n | ||||||
169<\/td>\n | 6.16.56 SINH 6.16.57 SECH 6.16.58 SQRT 6.16.59 SQRTPI <\/td>\n<\/tr>\n | ||||||
170<\/td>\n | 6.16.60 SUBTOTAL 6.16.61 SUM <\/td>\n<\/tr>\n | ||||||
171<\/td>\n | 6.16.62 SUMIF 6.16.63 SUMIFS <\/td>\n<\/tr>\n | ||||||
172<\/td>\n | 6.16.64 SUMPRODUCT 6.16.65 SUMSQ 6.16.66 SUMX2MY2 6.16.67 SUMX2PY2 <\/td>\n<\/tr>\n | ||||||
173<\/td>\n | 6.16.68 SUMXMY2 6.16.69 TAN 6.16.70 TANH <\/td>\n<\/tr>\n | ||||||
174<\/td>\n | 6.17 Rounding Functions 6.17.1 CEILING 6.17.2 INT 6.17.3 FLOOR <\/td>\n<\/tr>\n | ||||||
175<\/td>\n | 6.17.4 MROUND 6.17.5 ROUND 6.17.6 ROUNDDOWN <\/td>\n<\/tr>\n | ||||||
176<\/td>\n | 6.17.7 ROUNDUP 6.17.8 TRUNC 6.18 Statistical Functions 6.18.1 General 6.18.2 AVEDEV <\/td>\n<\/tr>\n | ||||||
177<\/td>\n | 6.18.3 AVERAGE 6.18.4 AVERAGEA 6.18.5 AVERAGEIF <\/td>\n<\/tr>\n | ||||||
178<\/td>\n | 6.18.6 AVERAGEIFS 6.18.7 BETADIST <\/td>\n<\/tr>\n | ||||||
179<\/td>\n | 6.18.8 BETAINV 6.18.9 BINOM.DIST.RANGE <\/td>\n<\/tr>\n | ||||||
180<\/td>\n | 6.18.10 BINOMDIST 6.18.11 LEGACY.CHIDIST 6.18.12 CHISQDIST <\/td>\n<\/tr>\n | ||||||
181<\/td>\n | 6.18.13 LEGACY.CHIINV 6.18.14 CHISQINV 6.18.15 LEGACY.CHITEST <\/td>\n<\/tr>\n | ||||||
182<\/td>\n | 6.18.16 CONFIDENCE 6.18.17 CORREL <\/td>\n<\/tr>\n | ||||||
183<\/td>\n | 6.18.18 COVAR 6.18.19 CRITBINOM 6.18.20 DEVSQ <\/td>\n<\/tr>\n | ||||||
184<\/td>\n | 6.18.21 EXPONDIST 6.18.22 FDIST <\/td>\n<\/tr>\n | ||||||
185<\/td>\n | 6.18.23 LEGACY.FDIST 6.18.24 FINV 6.18.25 LEGACY.FINV <\/td>\n<\/tr>\n | ||||||
186<\/td>\n | 6.18.26 FISHER 6.18.27 FISHERINV 6.18.28 FORECAST <\/td>\n<\/tr>\n | ||||||
187<\/td>\n | 6.18.29 FREQUENCY 6.18.30 FTEST 6.18.31 GAMMADIST <\/td>\n<\/tr>\n | ||||||
188<\/td>\n | 6.18.32 GAMMAINV 6.18.33 GAUSS 6.18.34 GEOMEAN <\/td>\n<\/tr>\n | ||||||
189<\/td>\n | 6.18.35 GROWTH <\/td>\n<\/tr>\n | ||||||
190<\/td>\n | 6.18.36 HARMEAN 6.18.37 HYPGEOMDIST <\/td>\n<\/tr>\n | ||||||
191<\/td>\n | 6.18.38 INTERCEPT 6.18.39 KURT 6.18.40 LARGE <\/td>\n<\/tr>\n | ||||||
192<\/td>\n | 6.18.41 LINEST <\/td>\n<\/tr>\n | ||||||
194<\/td>\n | 6.18.42 LOGEST <\/td>\n<\/tr>\n | ||||||
196<\/td>\n | 6.18.43 LOGINV 6.18.44 LOGNORMDIST <\/td>\n<\/tr>\n | ||||||
197<\/td>\n | 6.18.45 MAX 6.18.46 MAXA 6.18.47 MEDIAN <\/td>\n<\/tr>\n | ||||||
198<\/td>\n | 6.18.48 MIN 6.18.49 MINA <\/td>\n<\/tr>\n | ||||||
199<\/td>\n | 6.18.50 MODE 6.18.51 NEGBINOMDIST 6.18.52 NORMDIST <\/td>\n<\/tr>\n | ||||||
200<\/td>\n | 6.18.53 NORMINV 6.18.54 LEGACY.NORMSDIST 6.18.55 LEGACY.NORMSINV <\/td>\n<\/tr>\n | ||||||
201<\/td>\n | 6.18.56 PEARSON 6.18.57 PERCENTILE <\/td>\n<\/tr>\n | ||||||
202<\/td>\n | 6.18.58 PERCENTRANK <\/td>\n<\/tr>\n | ||||||
203<\/td>\n | 6.18.59 PERMUT 6.18.60 PERMUTATIONA <\/td>\n<\/tr>\n | ||||||
204<\/td>\n | 6.18.61 PHI 6.18.62 POISSON 6.18.63 PROB <\/td>\n<\/tr>\n | ||||||
205<\/td>\n | 6.18.64 QUARTILE 6.18.65 RANK <\/td>\n<\/tr>\n | ||||||
206<\/td>\n | 6.18.66 RSQ <\/td>\n<\/tr>\n | ||||||
207<\/td>\n | 6.18.67 SKEW 6.18.68 SKEWP <\/td>\n<\/tr>\n | ||||||
208<\/td>\n | 6.18.69 SLOPE 6.18.70 SMALL <\/td>\n<\/tr>\n | ||||||
209<\/td>\n | 6.18.71 STANDARDIZE 6.18.72 STDEV 6.18.73 STDEVA <\/td>\n<\/tr>\n | ||||||
210<\/td>\n | 6.18.74 STDEVP 6.18.75 STDEVPA <\/td>\n<\/tr>\n | ||||||
211<\/td>\n | 6.18.76 STEYX 6.18.77 LEGACY.TDIST <\/td>\n<\/tr>\n | ||||||
212<\/td>\n | 6.18.78 TINV 6.18.79 TREND <\/td>\n<\/tr>\n | ||||||
213<\/td>\n | 6.18.80 TRIMMEAN 6.18.81 TTEST <\/td>\n<\/tr>\n | ||||||
215<\/td>\n | 6.18.82 VAR 6.18.83 VARA <\/td>\n<\/tr>\n | ||||||
216<\/td>\n | 6.18.84 VARP 6.18.85 VARPA <\/td>\n<\/tr>\n | ||||||
217<\/td>\n | 6.18.86 WEIBULL 6.18.87 ZTEST <\/td>\n<\/tr>\n | ||||||
218<\/td>\n | 6.19 Number Representation Conversion Functions 6.19.1 General 6.19.2 ARABIC <\/td>\n<\/tr>\n | ||||||
219<\/td>\n | 6.19.3 BASE 6.19.4 BIN2DEC 6.19.5 BIN2HEX <\/td>\n<\/tr>\n | ||||||
220<\/td>\n | 6.19.6 BIN2OCT 6.19.7 DEC2BIN <\/td>\n<\/tr>\n | ||||||
221<\/td>\n | 6.19.8 DEC2HEX 6.19.9 DEC2OCT <\/td>\n<\/tr>\n | ||||||
222<\/td>\n | 6.19.10 DECIMAL 6.19.11 HEX2BIN 6.19.12 HEX2DEC <\/td>\n<\/tr>\n | ||||||
223<\/td>\n | 6.19.13 HEX2OCT 6.19.14 OCT2BIN <\/td>\n<\/tr>\n | ||||||
224<\/td>\n | 6.19.15 OCT2DEC 6.19.16 OCT2HEX 6.19.17 ROMAN <\/td>\n<\/tr>\n | ||||||
226<\/td>\n | 6.20 Text Functions 6.20.1 General 6.20.2 ASC <\/td>\n<\/tr>\n | ||||||
228<\/td>\n | 6.20.3 CHAR 6.20.4 CLEAN <\/td>\n<\/tr>\n | ||||||
229<\/td>\n | 6.20.5 CODE 6.20.6 CONCATENATE 6.20.7 DOLLAR 6.20.8 EXACT <\/td>\n<\/tr>\n | ||||||
230<\/td>\n | 6.20.9 FIND 6.20.10 FIXED 6.20.11 JIS <\/td>\n<\/tr>\n | ||||||
232<\/td>\n | 6.20.12 LEFT <\/td>\n<\/tr>\n | ||||||
233<\/td>\n | 6.20.13 LEN 6.20.14 LOWER 6.20.15 MID <\/td>\n<\/tr>\n | ||||||
234<\/td>\n | 6.20.16 PROPER 6.20.17 REPLACE 6.20.18 REPT <\/td>\n<\/tr>\n | ||||||
235<\/td>\n | 6.20.19 RIGHT 6.20.20 SEARCH 6.20.21 SUBSTITUTE <\/td>\n<\/tr>\n | ||||||
236<\/td>\n | 6.20.22 T 6.20.23 TEXT 6.20.24 TRIM <\/td>\n<\/tr>\n | ||||||
237<\/td>\n | 6.20.25 UNICHAR 6.20.26 UNICODE 6.20.27 UPPER <\/td>\n<\/tr>\n | ||||||
238<\/td>\n | 7 Other Capabilities 7.1 General 7.2 Inline constant arrays 7.3 Inline non-constant arrays 7.4 Year 1583 <\/td>\n<\/tr>\n | ||||||
239<\/td>\n | 8 Non-portable Features 8.1 General 8.2 Distinct Logical <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Open Document Format for Office Applications (OpenDocument) v1.2 – Recalculated Formula (OpenFormula) Format<\/b><\/p>\n |