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