2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e 0 0 96879 196671 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 1 0 0 0 0 2 0 0 0 0 0 75 60 true false Sheet2 1241 0 75 60 false true true true 12632256 true true true true true false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn cs CZ de DE en US nl NL true true 3 1 true 1 true lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM € € - tan aa zł - zł - - Kč - Kč - Kč - - Kč - Kč - Kč - - \ \ - \ - - - \ \ - \ - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 LARGE Function Result TRUE Sheet Result Description 1 TRUE Simple LARGE formulas with local references and values Function Expected Correct FunctionString Comment 1 2 Known y Known x I X Y RSQ() COR() STEYX() Data 1 900000000 900000000 TRUE =LARGE(I1:J24,2) 900000000 4 2 6 1 0.996892319188432 -0.99844495050475 1.60215046095659 3 2 10 10 TRUE =LARGE(I15:J38,2) 3 7 3 5 2 900000002 899999998 4 3 900000095 900000095 TRUE =LARGE(K1:X329,6) 4 8 9 11 3 900000003 899999997 5 4 Err:511 Err:511 TRUE =LARGE(K2:X330) 5 10 1 7 4 900000004 899999996 2 5 #VALUE! #VALUE! TRUE =LARGE(J1:J5,6) 8 5 5 900000005 899999995 3 6 #VALUE! #VALUE! TRUE =LARGE(J2:J6,5) 6 900000015 899999994 4 7 4 4.0000000000000000000 TRUE =LARGE(J2:J6,4) 7 900000007 899999993 5 8 #VALUE! #VALUE! TRUE =LARGE(J2:J6,5) 1 2 8 900000008 899999992 6 9 Err:502 Err:502 TRUE =LARGE(J2:J6,0) 900000000 4 9 900000009 899999991 4 10 Err:502 Err:502 TRUE =LARGE(J2:J6,-5) s 10 900000010 899999990 7 11 8 8 TRUE =LARGE(sl_j,2) p 11 900000011 899999989 12 9 9 TRUE =LARGE({1,5,8,9,6,3,2,5,7,1,2,5,8,7,41,6,9,6},3) 3 7 12 900000012 899999988 13 900000000 900000000 TRUE {=LARGE(I1:I10,{1;2;3})} 4 8 13 900000013 899999987 14 900000000 900000000 TRUE {=LARGE(I1:I10,{1;2;3})} 5 10 14 900000014 899999986 15 5 5 TRUE {=LARGE(I1:I10,{1;2;3})} 15 900000015 899999985 16 16 900000016 899999984 17 1 2 17 900000017 899999983 18 900000000 4 18 900000018 899999982 19 0 19 900000019 899999981 20 0 20 900000020 899999980 21 3 7 21 900000021 899999979 22 4 8 22 900000022 899999978 23 5 10 23 900000023 899999977 24 24 900000024 899999976 25 25 900000025 899999975 26 26 900000026 899999974 27 27 900000027 899999960 28 9 9 TRUE =AVERAGE(LARGE(I29:I38,{1,2,3})) AOO#32345 /Eike 1 28 900000028 899999972 29 -2 -2 TRUE =MDETERM(LARGE(I30:I39,{1,2;3,4})) 2 29 900000029 899999971 30 3 30 900000030 899999970 31 4 31 900000031 899999969 32 5 32 900000032 899999968 33 6 33 900000033 899999967 34 7 34 900000034 899999966 35 8 35 900000035 899999965 36 9 36 900000036 899999964 37 10 37 900000037 899999963 38 38 900000038 899999962 39 39 900000039 899999961 40 40 900000040 899999960 41 41 900000041 899999959 42 42 900000042 899999958 43 43 900000043 899999957 44 44 900000044 899999956 45 45 900000045 899999955 46 46 900000046 899999954 47 47 900000047 899999953 48 48 900000048 899999952 49 49 900000049 899999951 50 50 900000050 899999950 51 51 900000051 899999949 52 52 900000052 899999948 53 53 900000053 899999947 54 54 900000054 899999946 55 55 900000055 899999945 56 56 900000056 899999944 57 57 900000057 899999943 58 58 900000058 899999942 59 59 900000059 899999941 60 60 900000060 899999940 61 61 900000061 899999939 62 62 900000062 899999938 63 63 900000063 899999937 64 64 900000064 899999936 65 65 900000065 899999935 66 66 900000066 899999934 67 67 900000067 899999933 68 68 900000068 899999932 69 69 900000069 899999931 70 70 900000070 899999930 71 71 900000071 899999929 72 72 900000072 899999928 73 73 900000073 899999927 74 74 900000074 899999926 75 75 900000075 899999925 76 76 900000076 899999924 77 77 900000077 899999923 78 78 900000078 899999922 79 79 900000079 899999921 80 80 900000080 899999920 81 81 900000081 899999919 82 82 900000082 899999918 83 83 900000083 899999917 84 84 900000084 899999916 85 85 900000085 899999915 86 86 900000086 899999914 87 87 900000087 899999913 88 88 900000088 899999912 89 89 900000089 899999911 90 90 900000090 899999910 91 91 900000091 899999909 92 92 900000092 899999908 93 93 900000093 899999907 94 94 900000094 899999906 95 95 900000095 899999905 96 96 900000096 899999904 97 97 900000097 899999903 98 98 900000098 899999902 99 99 900000099 899999901 100 100 900000100 899999900 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327