2016-09-13T23:06:29.328060293en-US1P0DLibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a8a7b7114d96b2013b00e9bc0ced81aad5495457 0 0 47175 14118 view1 2 8 0 0 0 0 2 0 0 0 0 0 65 60 true false 1 16 0 0 0 0 2 0 0 0 0 0 65 60 true false Sheet2 1241 0 65 60 false true true true 12632256 true true true true false 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 en US true true 3 1 true 1 true kQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 $ - $ : : : : ( ) - TRUE TRUE FALSE ( ) ( ) ( ) ( ) / / - - - - : : : : : : / / : ( ) ( ) ( ) - ( ) - ( ) - ( ) - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 ??? Page 1 ??? Page 1 F.TEST Function Result 1 Sheet Result Description 1 1 Simple F.TEST formulas with local references and values Function Expected Correct FunctionString Comment Data1 Data2 1E-10 1.1 0.648317846786175 0.648317846786175 TRUE =F.TEST(I2:I6,J2:J6) 6 20 2E-10 1.2 4.01165999999994E-245 4.0116600000001E-245 TRUE =F.TEST(L1:L29,M1:M29) 7 28 3E-10 1.3 0.0625 0.0625 TRUE =F.TEST(I10:I12,J10:J12) 9 31 4E-10 1.4 0.0625 0.0625 TRUE =F.TEST({5,9,12},{45,56,18}) 15 38 5E-10 1.5 0.0625 0.0625 TRUE =F.TEST(ra1a,ra1b) 21 40 6E-10 1.6 #VALUE! #VALUE! TRUE =F.TEST(I15:I17,J15:J17) 7E-10 1.7 #VALUE! #VALUE! TRUE =F.TEST(I20:I22,J20:J22) 8E-10 1.8 9E-10 1.9 5 45 1E-09 2 9 56 1.1E-09 2.1 12 18 1.2E-09 2.2 1.3E-09 2.3 1.4E-09 2.4 0.0 0 1.5E-09 2.5 0 1.6E-09 2.6 0 1.7E-09 2.7 1.8E-09 2.8 1.9E-09 2.9 1 2E-09 3 1 2.1E-09 3.1 1 2.2E-09 3.2 2.3E-09 3.3 2.4E-09 3.4 2.5E-09 3.5 2.6E-09 3.6 2.7E-09 3.7 2.8E-09 3.8 2.9E-09 3.9