2017-02-24T18:54:42.931133976P0D1LibreOfficeDev/6.1.0.0.alpha0$Linux_X86_64 LibreOffice_project/6e31851e72520ce08e5cd2bf1f3aaa9f100a3eff 0 0 45753 18813 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 2 1 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet2 1459 0 100 60 false true true true 12632256 true true true true true false false 1270 1270 1 1 true false 7 true false false 0 false iQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAqgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm Generic Printer cs CZ de DE en US nl NL true 3 true false true true 12632256 true true false true false true false true 1 false 1270 1270 false 1 true - ( ) - - - - - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ - - / / / / - - - - - - - - - - - - - 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 - - : : : : - - ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - ( ) ok ERR! - - - - Kč - - - - ¥€ ( ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - - - - - : : : - - - - - - - - - - : : : : : : - - : - - - - - - - - - - - - % / / ??? Page 1 ???(???) 00/00/0000, 00:00:00 Page 1/ 99 T.DIST.RT Function Result TRUE Sheet Result Description 1 TRUE Simple T.DIST.RT formulas with local references and values Function Expected Correct FunctionString Comment 1 10 1 0 Data Data 0.17044656615103 0.17044656615103 TRUE =T.DIST.RT(1, 10) 2 11 2 0 Known y Known x 1.959999998 0.17044656615103 0.17044656615103 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 3 12 3 0 2 6 60 0.035401977534017 0.035401977534017 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 4 13 4 0 3 5 0.005533347843017 0.005533347843017 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 5 14 5 0 9 11 0.000756039679406 0.000756039679406 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 6 15 6 0 1 7 9.7257653128633E-05 9.7257653128633E-05 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 7 16 7 0 8 5 1.21632727555193E-05 1.21632727555193E-05 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 8 17 8 0 7 4 1.49794463195888E-06 1.49794463195888E-06 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 9 18 9 0 5 4 1.82496662157233E-07 1.82496662157233E-07 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 10 19 10 0 2.20213936459103E-08 2.20213936459103E-08 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 11 20 11 0 2.63151308116795E-09 2.63151308116795E-09 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 3.1123250806477E-10 3.1123250806477E-10 TRUE {=T.DIST.RT(F1:F11,G1:G11)} 0.25 0.25 TRUE =T.DIST.RT(F1,H1) 0.091751709536137 0.091751709536137 TRUE =T.DIST.RT(F2,H2) 654654 654 1 0.028834442811219 0.028834442811219 TRUE =T.DIST.RT(F3,H3) 0.008065044950046 0.008065044950046 TRUE =T.DIST.RT(F4,H4) 0.002052357990027 0.002052357990027 TRUE =T.DIST.RT(F5,H5) 0.000482267597208 0.000482267597208 TRUE =T.DIST.RT(F6,H6) 0.000105777425973 0.000105777425973 TRUE =T.DIST.RT(F7,H7) 0 0 TRUE =T.DIST.RT(F15,G15) 0.000486711984885 0.000486711984885 TRUE =T.DIST.RT(G15,H15) 4.62131557658376E-002 0.046213155765838 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 1.50496239487313E-002 0.015049623948731 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 1.04807918350441E-006 1.04807918350441E-06 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 1.75308331410104E-001 0.175308331410104 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 2.46453330286222E-004 0.000246453330286 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 1.09606490334647E-003 0.001096064903346 TRUE {=T.DIST.RT(L3:L9,M3:M9)} 3.74521694063726E-003 0.003745216940637 TRUE {=T.DIST.RT(L3:L9,M3:M9)} Err:502 Err:502 TRUE =T.DIST.RT(2,0.9) 5.00000000000000E-001 0.5 TRUE =T.DIST.RT(0,9) 8.28281801931043E-001 0.828281801931043 TRUE =T.DIST.RT(-1,9) 0.027322464987961 0.027322464987961 TRUE =T.DIST.RT(O2,O3)