2017-01-13T17:19:27.766903163P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/63ddc8dc4ae1f3c3ee2f860c34886688b0ed2d57 0 0 45753 18813 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 1 0 0 0 0 2 0 0 0 0 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ł € - € : : : : € - € € - € ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - € ( € ) ok ERR! - - Kč - Kč - Kč - - Kč - Kč - Kč ¥€ ( € ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 T.DIST.2T Function Result TRUE Sheet Result Description 1 TRUE Simple T.DIST.2T formulas with local references and values Function Expected Correct FunctionString Comment 1 10 1 0 Data Data 0.34089313230206 0.34089313230206 TRUE =T.DIST.2T(1, 10) 2 11 2 0 Known y Known x 1.959999998 0.34089313230206 0.34089313230206 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 3 12 3 0 2 6 60 0.070803955068035 0.070803955068035 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 4 13 4 0 3 5 0.011066695686034 0.011066695686034 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 5 14 5 0 9 11 0.001512079358812 0.001512079358812 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 6 15 6 0 1 7 0.000194515306257 0.000194515306257 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 7 16 7 0 8 5 2.43265455110385E-05 2.43265455110385E-05 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 8 17 8 0 7 4 2.99588926391775E-06 2.99588926391775E-06 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 9 18 9 0 5 4 3.64993324314466E-07 3.64993324314466E-07 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 10 19 10 0 4.40427872918206E-08 4.40427872918206E-08 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 11 20 11 0 5.26302616233589E-09 5.26302616233589E-09 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 6.2246501612954E-10 6.2246501612954E-10 TRUE {=T.DIST.2T(F1:F11,G1:G11)} 0.5 0.5 TRUE =T.DIST.2T(F1,H1) 0.183503419072274 0.183503419072274 TRUE =T.DIST.2T(F2,H2) 654654 654 1 0.057668885622437 0.057668885622437 TRUE =T.DIST.2T(F3,H3) 0.016130089900093 0.016130089900093 TRUE =T.DIST.2T(F4,H4) 0.004104715980053 0.004104715980053 TRUE =T.DIST.2T(F5,H5) 0.000964535194415 0.000964535194415 TRUE =T.DIST.2T(F6,H6) 0.000211554851946 0.000211554851946 TRUE =T.DIST.2T(F7,H7) 0 0 TRUE =T.DIST.2T(F15,G15) 0.00097342396977 0.00097342396977 TRUE =T.DIST.2T(G15,H15) 9.24263115316751E-002 0.092426311531675 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 3.00992478974626E-002 0.030099247897463 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 2.09615836700881E-006 2.09615836700881E-06 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 3.50616662820207E-001 0.350616662820207 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 4.92906660572444E-004 0.000492906660572 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 2.19212980669294E-003 0.002192129806693 TRUE {=T.DIST.2T(L3:L9,M3:M9)} 7.49043388127452E-003 0.007490433881275 TRUE {=T.DIST.2T(L3:L9,M3:M9)} Err:502 #NAME? TRUE =T.DIST.2T(2,0.9) 1.00000000000000E+000 1 TRUE =T.DIST.2T(0,9) Err:502 #NAME? TRUE =T.DIST.2T(-1,9) 0.054644929975921 0.054644929975921 TRUE =T.DIST.2T(O2,O3)