2017-02-13T17:55:32.263157328P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/2aea0d0148ea0940da2b32387c330f9aa590294c 0 0 49420 21043 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.INV.2T Function Result TRUE Sheet Result Description 1 TRUE Simple T.INV.2T formulas with local references and values Function Expected Correct FunctionString Comment 0.1 10 1 0 Data Data 0 0 TRUE =T.INV.2T(1, 10) 0.15 11 2 0 Known y Known x 1.959999998 1.81246112281168 1.81246112281168 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.2 12 3 0 0.2222222 6 60 1.54755976627494 1.54755976627494 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.25 13 4 0 0.3333333 5 1.35621733402321 1.35621733402321 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.3 14 5 0 0.4444444 11 1.20414624166526 1.20414624166526 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.35 15 6 0 0.5555555 7 1.07628024458382 1.07628024458382 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.4 16 7 0 0.6666666 5 0.964682373011799 0.964682373011799 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.45 17 8 0 0.7777777 4 0.864667001798292 0.864667001798292 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.5 18 9 0 0.8888888 4 0.773238555461204 0.773238555461204 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.55 19 10 0 0.688363806466199 0.688363806466199 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.6 20 11 0 0.608595649161802 0.608595649161802 TRUE {=T.INV.2T(F1:F11,G1:G11)} 0.532862791616333 0.532862791616333 TRUE {=T.INV.2T(F1:F11,G1:G11)} 6.31375151467504 6.31375151467504 TRUE =T.INV.2T(F1,H1) 2.28193058772768 2.28193058772768 TRUE =T.INV.2T(F2,H2) 0.9 113 1 1.63774435369621 1.63774435369621 TRUE =T.INV.2T(F3,H3) 1.34439755550909 1.34439755550909 TRUE =T.INV.2T(F4,H4) 1.15576734289429 1.15576734289429 TRUE =T.INV.2T(F5,H5) 1.01334886886574 1.01334886886574 TRUE =T.INV.2T(F6,H6) 0.896029644313764 0.896029644313764 TRUE =T.INV.2T(F7,H7) 0.125944078921444 0.125944078921444 TRUE =T.INV.2T(F15,G15) 0 0 TRUE =T.INV.2T(H15,G15) 1.36163241825017E+000 1.36163241825017 TRUE {=T.INV.2T(L3:L9,M3:M9)} 1.07048007301100E+000 1.070480073011 TRUE {=T.INV.2T(L3:L9,M3:M9)} 7.93181382641255E-001 0.793181382641255 TRUE {=T.INV.2T(L3:L9,M3:M9)} 6.18938866571943E-001 0.618938866571943 TRUE {=T.INV.2T(L3:L9,M3:M9)} 4.57258216476513E-001 0.457258216476513 TRUE {=T.INV.2T(L3:L9,M3:M9)} 3.01894783862139E-001 0.301894783862139 TRUE {=T.INV.2T(L3:L9,M3:M9)} 1.48831111963765E-001 0.148831111963765 TRUE {=T.INV.2T(L3:L9,M3:M9)} Err:502 #NAME? TRUE =T.INV.2T(2,0.9) Err:502 #NAME? TRUE =T.INV.2T(0,9) Err:502 #NAME? TRUE =T.INV.2T(-1,9) Err:502 #NAME? TRUE =T.INV.2T(O2,O3) 1.94318028051530E+000 1.9431802805153 TRUE =T.INV.2T(0.1,6) 3.65148371670111E-001 0.365148 TRUE =T.INV.2T(0.75,2) 3.65148371670111E-001 0.365148 TRUE =T.INV.2T(0.75,2.8) Err:502 #NAME? TRUE =T.INV.2T(0.44,0.8)