2017-01-06T19:21:00.238935917P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/6bd7451ecd66417a4e8b8dff3874c15ba4d1536e 0 0 57396 34184 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 24 0 0 0 0 2 0 0 0 18 0 100 60 true false Sheet2 1241 0 100 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ł € - € : : : : € - € € - € / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 PERCENTRANK.INC Function Result TRUE Sheet Result Description 1 TRUE Simple PERCENTRANK.INC formulas with local references and values Function Expected Correct FunctionString Comment Data 0.001 1E+016 Data Data Data Data 0.6667 0.6667 TRUE =PERCENTRANK.INC(I2:I5,3,4) 1 0.004 1E+016 1 13 1 13 0.667 0.667 TRUE =PERCENTRANK.INC(I2:I5,3) 3 0.007 1E+016 2 12 2 12 0.887 0.887 TRUE =PERCENTRANK.INC(K1:K57,0.15) 2 0.01 1E+016 3 11 3 11 0 0 TRUE =PERCENTRANK.INC(L1:L57,L45) 4 0.013 1E+016 6 8 6 8 1 1 TRUE =PERCENTRANK.INC(I9:I11,I11,5) 0.016 1E+016 6 4 6 4 0.4 0.4 TRUE =PERCENTRANK.INC(N2:N11,N6,1) 0.019 1E+016 6 3 6 3 0.171428571428571 0.171428571428571 TRUE =PERCENTRANK.INC(I2:N11,K6,44) 0.022 1E+016 7 2 7 2 0.67 0.67 TRUE =PERCENTRANK.INC({1,2,3,4}, 3, 2) -1 0.025 1E+016 8 1 8 1 0.667 0.667 TRUE =PERCENTRANK.INC({1,2,3,4}, 3) 0 0.028 1E+016 9 1 9 1 0.83 0.83 TRUE =PERCENTRANK.INC({1,2,3,4}, 3.5, 2) 1 0.031 1E+016 1 1 0.758 0.758 TRUE =PERCENTRANK.INC({7,8,9,20}, 12) 0.034 1E+016 0.333 0.333 TRUE =PERCENTRANK.INC(P2:P11,2) 0.037 1E+016 0.556 0.556 TRUE =PERCENTRANK.INC(P2:P11,4) 0.04 1E+016 0.667 0.667 TRUE =PERCENTRANK.INC(P2:P11,8) 0.043 1E+016 0.583 0.583 TRUE =PERCENTRANK.INC(P2:P11,5) 0.046 1E+016 0.594 0.594 TRUE =PERCENTRANK.INC(P2:P11,5.4) 0.049 1E+016 1 1 TRUE =PERCENTRANK.INC(I2,1,1) 0.052 1E+016 #VALUE! #VALUE! TRUE =PERCENTRANK.INC(I2,-1,1) 0.055 1E+016 #VALUE! #VALUE! TRUE =PERCENTRANK.INC(I2,0,1) 0.058 1E+016 Err:502 0 TRUE =PERCENTRANK.INC(I2,1,0) 0.061 1E+016 Err:502 0 TRUE =PERCENTRANK.INC(I2,1,-1) 0.064 1E+016 0.75 0.75 TRUE =PERCENTRANK.INC(R2:R10, 7) 0.067 1E+016 0.351 0.351 TRUE =PERCENTRANK.INC(R2:R10,5.43) 0.07 1E+016 0.4 0.4 TRUE =PERCENTRANK.INC(R2:R10,5.43,1) 0.073 1E+016 0.333 0.333 TRUE =PERCENTRANK.INC(T2:T11,2) 0.076 1E+016 0.556 0.556 TRUE =PERCENTRANK.INC(T2:T11,4) 0.079 1E+016 0.667 0.667 TRUE =PERCENTRANK.INC(T2:T11,8) 0.082 1E+016 0.583 0.583 TRUE =PERCENTRANK.INC(T2:T11,5) 0.085 1E+016 0.088 1E+016 0.091 1E+016 0.094 1E+016 0.097 1E+016 0.1 1E+016 0.103 1E+016 0.106 1E+016 0.109 1E+016 0.112 1E+016 0.115 1E+016 0.118 1E+016 0.121 1E+016 0.124 1E+016 0.127 1E+016 0.13 1E+016 0.133 1E+016 0.136 1E+016 0.139 1E+016 0.142 1E+016 0.145 1E+016 0.148 1E+016 0.151 1.00000000000001E+016 0.154 1.00000000000001E+016 0.157 1.00000000000001E+016 0.16 1.00000000000001E+016 0.163 1.00000000000001E+016 0.166 1.00000000000001E+016 0.169 1.00000000000001E+016