Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € . . WAHR WAHR FALSCH $ - $ € - € € - € руб. - руб. / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 LOGEST Function Result TRUE Sheet Result Description 1 TRUE Simple LOGEST formulas with local references and values Function Expected Correct FunctionString Comment x1 x2 y LINEST value Known y Known x Month Sales Floor space (x1) Offices (x2) Entrances (x3) Age (x4) Assessed value (y) 1.04333180072885 1.04333180072885 TRUE =K17 4 7 100 4,17 -3,48 82,33 1 0 1 3100 2310 2 20 142000 0.007249461757928 0.007249461757928 TRUE =K18 5 9 105 5,46 10,96 9,35 9 4 2 4500 2333 2 12 144000 0.872574040951189 0.872574040951189 TRUE =K19 6 11 104 0,87 5,06 #NA 5 2 3 4400 2356 3 1.5 33 151000 34.2384725790819 34.2384725790819 TRUE =K20 7 12 108 13,21 4 #NA 7 3 4 5400 2379 3 2 43 150000 0.050382990289904 0.050382990289904 TRUE =K21 8 15 111 675,45 102,26 #NA Result (slope) Result (y-intercept) 5 7500 2402 2 3 53 139000 82.5576827252648 82.5576827252647 TRUE =L17 9 17 120 2 1 6 8100 2425 4 2 23 169000 0.05277687823585 0.05277687823585 TRUE =L18 10 19 133 Formula (array formula in cells A7:B7) Formula Result 2448 2 1.5 99 126000 0.038360545901099 0.038360545901099 TRUE =L19 2 1 $11,000 2471 2 34 142900 5 5 TRUE =L20 Calculates the estimate of the sales in the ninth month, based on sales in months 2 through 6. 2494 3 23 163000 0.007357657409152 0.007357657409152 TRUE =L21 2517 4 55 169000 1.10286912552017 1.10286912552017 TRUE =LOGEST({2,3,5,7,10},{4,6,10,14,20},1,0) 2540 2 3 22 149000 1.10286912552017 1.10286912552017 TRUE =K25 -234.2371645 1.60392806375267 1.60392806375267 TRUE =L25 13.26801148 2 2 TRUE =R9 0.996747993 1 1 TRUE =S9 459.7536742 2672.41129180003 2672.41129180003 TRUE =SUM(LOGEST(V2:V6, U2:U6)*{9,1}) 1.04333180072885 82.5576827252648 1732393319 0.998307311395751 0.998307311395751 TRUE =K29 0.007249461757928 0.05277687823585 Formula (array formula entered in A14:A18) 8.22132224295928E-05 8.22132224295928E-05 TRUE =K30 0.872574040951189 0.038360545901099 Err:502 0.997224228993195 0.997224228993195 TRUE =K31 34.2384725790819 5 538.890398315583 538.890398315583 TRUE =K32 0.050382990289904 0.007357657409152 0.077963872493239 0.077963872493239 TRUE =K33 1.01810621384184 1.01810621384184 TRUE =L29 0.003288210980578 0.003288210980578 TRUE =L30 0.006014042360866 0.006014042360866 TRUE =L31 1.10286912552017 1.60392806375267 6 6 TRUE =L32 0.00021701223311 0.00021701223311 TRUE =L33 1.08543473416676 1.08543473416676 TRUE =M29 0.002478953535417 0.002478953535417 TRUE =M30 0.998307311395751 1.01810621384184 1.08543473416676 1.00017437377135 80387.1472131755 #N/A error TRUE =M31 8.22132224295928E-05 0.003288210980578 0.002478953535417 3.36422934631347E-05 0.075826956681882 #N/A error TRUE =M32 0.997224228993195 0.006014042360866 #N/A #N/A #N/A #N/A error TRUE =M33 538.890398315583 6 #N/A #N/A #N/A 1.00017437377135 1.00017437377135 TRUE =N29 0.077963872493239 0.00021701223311 #N/A #N/A #N/A 3.36422934631347E-05 3.36422934631347E-05 TRUE =N30 #N/A error TRUE =N31 #N/A error TRUE =N32 #N/A error TRUE =N33 80387.1472131755 80387.1472131755 TRUE =O29 0.075826956681882 0.075826956681882 TRUE =O30 #N/A error TRUE =O31 #N/A error TRUE =O32 #N/A error TRUE =O33 4 O5 yes 1 no 2 yes 3