2017-01-13T17:19:49.893771096P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/63ddc8dc4ae1f3c3ee2f860c34886688b0ed2d57 0 0 81398 19371 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 7 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 TDIST Function Result TRUE Sheet Result Description 1 TRUE Simple TDIST formulas with local references and values Function Expected Correct FunctionString Comment 1 10 1 Data Data Day Temp (F) 0.17044656615103 0.17044656615103 TRUE =TDIST(1, 10, 1) 2 11 2 Known y Known x 1.959999998 1/7/2011 89 0.005304673632623 0.005304673632623 TRUE =TDIST(60,1,1) 3 12 1 2 6 60 2/7/2011 88 0.666666666666667 0.666666666666667 TRUE =TDIST(0.5, 2, 2) 4 13 2 3 5 3/7/2011 92 0.17044656615103 0.17044656615103 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 5 14 1 9 11 4/7/2011 101 0.070803955068035 0.070803955068035 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 6 15 2 1 7 5/7/2011 94 0.005533347843017 0.005533347843017 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 7 16 1 8 5 6/7/2011 97 0.001512079358812 0.001512079358812 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 8 17 2 7 4 7/7/2011 95 9.7257653128633E-05 9.7257653128633E-05 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 9 18 1 5 4 2.43265455110385E-05 2.43265455110385E-05 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 10 19 2 1.49794463195888E-06 1.49794463195888E-06 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 11 20 1 3.64993324314466E-07 3.64993324314466E-07 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 2.20213936459103E-08 2.20213936459103E-08 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 5.26302616233589E-09 5.26302616233589E-09 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 3.1123250806477E-10 3.1123250806477E-10 TRUE {=TDIST(F1:F11,G1:G11,H1:H11)} 654654 654 1 0.031725517430554 0.031725517430554 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 0.008163401865824 0.008163401865824 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 0.000622507900395 0.000622507900395 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 0.000202039948798 0.000202039948798 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 1.67178903199424E-05 1.67178903199424E-05 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 5.53024013859057E-06 5.53024013859057E-06 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 4.52320493698296E-07 4.52320493698296E-07 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 1.45521084829415E-007 1.45521084829415E-07 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 1.14736154398850E-008 1.1473615439885E-08 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 3.54133179010740E-009 3.5413317901074E-09 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 2.67216253926755E-010 2.67216253926755E-10 TRUE {=TDIST(G1:G11,F1:F11,H1:H11)} 0.00000000000000E+000 0 TRUE =TDIST(F15,G15,H15) Err:502 Err:502 TRUE =TDIST(-12,G1,H1) Err:502 Err:502 TRUE =TDIST(155,-1,0) Err:502 Err:502 TRUE =TDIST(155,0.8,0) 0.054644929975921 0.054644929975921 TRUE =TDIST(O2,O3,2) 0.027322464987961 0.027322464987961 TRUE =TDIST(O2,O3,1) 5.00000000000000E-001 0.5 TRUE =TDIST(0,G1,H1) Err:502 Err:502 TRUE =TDIST(-12,G1,3)