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 / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 FORECAST Function Result TRUE Sheet Result Description 1 TRUE Simple FORECAST formulas with local references and values Function Expected Correct FunctionString Comment 3 0.700000000000000 1 2 Known Y Known X 2 125.2 13 13 TRUE =FORECAST(6, N1:N5, M1:M5) 4 0.300000000000000 2 4 6 20 4 118.9 10.6072530864198 10.6072530864198 TRUE =FORECAST(30,P2:P6,Q2:Q6) 3 7 7 28 6 106.0 112.723528625461 112.723528625461 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} #VALUE! Eike, Winfried 4 8 9 31 4 118.9 113.884297881556 113.884297881556 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 5 11 15 38 5 111.5 115.045067137652 115.045067137652 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 21 40 6 106.0 113.884297881556 113.884297881556 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 7 105.0 114.464682509604 114.4646825096040000000 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 8 109.5 115.045067137652 115.045067137652 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 9 117.5 115.6254517657 115.6254517657 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 10 125.6 116.205836393748 116.205836393748 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 11 130.2 116.786221021796 116.786221021796 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 12 129.3 117.366605649844 117.366605649844 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 13 123.6 117.946990277891 117.946990277891 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 14 115.9 118.527374905939 118.527374905939 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 15 110.1 119.107759533987 119.107759533987 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 16 109.1 119.688144162035 119.688144162035 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 17 113.7 120.268528790083 120.268528790083 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 18 122.0 120.848913418131 120.848913418131 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 19 130.4 121.429298046179 121.429298046179 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 20 135.1 122.009682674226 122.009682674226 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 21 134.2 122.590067302274 122.590067302274 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 22 128.2 123.170451930322 123.170451930322 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 23 120.2 123.75083655837 123.75083655837 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 24 114.2 124.331221186418 124.331221186418 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 25 113.1 124.911605814466 124.911605814466 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 26 117.9 125.491990442514 125.491990442514 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} Excel 125,491990442513000000 27 126.5 126.072375070561 126.072375070561 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 28 135.2 126.652759698609 126.652759698609 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 29 140.1 127.233144326657 127.233144326657 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 30 139.1 127.813528954705 127.813528954705 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 31 132.9 128.393913582753 128.393913582753 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 32 124.6 128.974298210801 128.974298210801 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 33 118.3 129.554682838849 129.554682838849 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 34 117.2 130.135067466896 130.135067466896 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 35 122.1 130.715452094944 130.715452094944 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 36 131.0 131.295836722992 131.295836722992 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 37 140.0 131.87622135104 131.87622135104 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 38 145.0 132.456605979088 132.456605979088 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 39 144.0 133.036990607136 133.036990607136 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 133.617375235183 133.617375235183 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} 134.197759863231 134.197759863231 TRUE {=FORECAST(S1:S39,T1:T39,S1:S39)} -10.6658950617284 -10.665895 TRUE =FORECAST(0,P2:P6,Q2:Q6) -31.9390432098765 -31.939043 TRUE =FORECAST(-30,P2:P6,Q2:Q6) 5 5.000000 TRUE =FORECAST(8, {1,2,3}, {4,5,6}) 10.6571428571429 10.657143 TRUE =FORECAST(7, {5.8,-1}, {2,-5}) -5 -5.000000 TRUE =FORECAST(50, {-1,-2,-3,-4}, {10,20,30,40}) 4