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ł € - € : : : : € - € € - € / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 NORMSDIST Function Result TRUE Sheet Result Description 1 TRUE Simple NORMSDIST formulas with local references and values Function Expected Correct FunctionString Comment 0.1 5 0.25 -3 -4.5 0.841344746068543 0.841344746068543 TRUE =NORMSDIST(1) 0.2 6 0.35 -4 -4.4 0.908788725604095 0.908788725604095 TRUE =NORMSDIST(1.333333) 0.3 7 0.45 -5 -4.3 0.539827837277029 0.539827837277029 TRUE {=NORMSDIST(M1:M8)} 0.4 8 0.55 -6 -4.2 0.579259709439103 0.579259709439103 TRUE {=NORMSDIST(M1:M8)} 0.5 9 0.65 -8.2 -4.1 0.617911422188953 0.617911422188953 TRUE {=NORMSDIST(M1:M8)} 0.6 10 0.75 -8.3 -4 0.655421741610324 0.655421741610324 TRUE {=NORMSDIST(M1:M8)} 0.7 11 0.85 -3.9 0.691462461274013 0.691462461274013 TRUE {=NORMSDIST(M1:M8)} 0.8 12 0.95 -3.8 0.725746882249926 0.725746882249926 TRUE {=NORMSDIST(M1:M8)} -3.7 0.758036347776927 0.758036347776927 TRUE {=NORMSDIST(M1:M8)} -3.6 0.788144601416603 0.788144601416603 TRUE {=NORMSDIST(M1:M8)} -3.5 0.999999713348428 0.999999713348428 TRUE {=NORMSDIST(N1:N8)} -3.4 0.999999999013412 0.999999999013412 TRUE {=NORMSDIST(N1:N8)} -3.3 0.99999999999872 0.99999999999872 TRUE {=NORMSDIST(N1:N8)} -3.2 1 1 TRUE {=NORMSDIST(N1:N8)} -3.1 1 1 TRUE {=NORMSDIST(N1:N8)} -3 1 1 TRUE {=NORMSDIST(N1:N8)} -2.9 1 1 TRUE {=NORMSDIST(N1:N8)} -2.8 1 1 TRUE {=NORMSDIST(N1:N8)} -2.7 0.598706325682924 0.598706325682924 TRUE {=NORMSDIST(O1:O8)} -2.6 0.636830651175619 0.636830651175619 TRUE {=NORMSDIST(O1:O8)} -2.5 0.67364477971208 0.67364477971208 TRUE {=NORMSDIST(O1:O8)} -2.4 7.08840313211654E-001 0.708840313211654 TRUE {=NORMSDIST(O1:O8)} -2.3 7.42153889194135E-001 0.742153889194135 TRUE {=NORMSDIST(O1:O8)} -2.2 7.73372647623132E-001 0.773372647623132 TRUE {=NORMSDIST(O1:O8)} -2.1 8.02337456877308E-001 0.802337456877308 TRUE {=NORMSDIST(O1:O8)} -2 8.28943873691518E-001 0.828943873691518 TRUE {=NORMSDIST(O1:O8)} -1.9 0.00134989803163 0.00134989803163 TRUE {=NORMSDIST(Q1:Q6)} -1.8 3.167124183312E-05 3.167124183312E-05 TRUE {=NORMSDIST(Q1:Q6)} -1.7 2.86651571879195E-07 2.86651571879195E-07 TRUE {=NORMSDIST(Q1:Q6)} -1.6 9.86587645037701E-10 9.86587645037701E-10 TRUE {=NORMSDIST(Q1:Q6)} -1.5 1.20193515427359E-16 1.20193515427359E-16 TRUE {=NORMSDIST(Q1:Q6)} -1.4 5.20556974489029E-17 5.20556974489029E-17 TRUE {=NORMSDIST(Q1:Q6)} -1.3 1.89895624658878E-08 1.89895624658878E-08 TRUE =NORMSDIST(-5.5) -1.2 3.39767312473006E-06 0.000003 TRUE {=NORMSDIST(R1:R49)} -1.1 5.41254390770386E-06 0.000005 TRUE {=NORMSDIST(R1:R49)} -1 8.53990547099182E-06 0.000009 TRUE {=NORMSDIST(R1:R49)} -0.9 1.33457490159063E-05 0.000013 TRUE {=NORMSDIST(R1:R49)} -0.8 2.06575069125468E-05 0.000021 TRUE {=NORMSDIST(R1:R49)} -0.7 3.167124183312E-05 0.000032 TRUE {=NORMSDIST(R1:R49)} -0.6 4.80963440176028E-05 0.000048 TRUE {=NORMSDIST(R1:R49)} -0.5 7.23480439251201E-05 0.000072 TRUE {=NORMSDIST(R1:R49)} -0.4 0.000107799733477 0.000108 TRUE {=NORMSDIST(R1:R49)} -0.3 0.000159108590158 0.000159 TRUE {=NORMSDIST(R1:R49)} -0.2 0.000232629079036 0.000232629079036 TRUE {=NORMSDIST(R1:R49)} -0.1 0.000336929265677 0.000336929265677 TRUE {=NORMSDIST(R1:R49)} 0 0.000483424142384 0.000483424142384 TRUE {=NORMSDIST(R1:R49)} 0.100000000000001 0.000687137937916 0.000687 TRUE {=NORMSDIST(R1:R49)} 0.2 0.000967603213218 0.000967603213218 TRUE {=NORMSDIST(R1:R49)} 0.300000000000001 0.00134989803163 0.00134989803163 TRUE {=NORMSDIST(R1:R49)} 0.001865813300384 0.001865813300384 TRUE {=NORMSDIST(R1:R49)} 0.002555130330428 0.002555130330428 TRUE {=NORMSDIST(R1:R49)} 0.003466973803041 0.003466973803041 TRUE {=NORMSDIST(R1:R49)} 0.004661188023719 0.004661 TRUE {=NORMSDIST(R1:R49)} 0.006209665325776 0.006210 TRUE {=NORMSDIST(R1:R49)} 0.008197535924596 0.008198 TRUE {=NORMSDIST(R1:R49)} 0.010724110021676 0.010724 TRUE {=NORMSDIST(R1:R49)} 0.013903447513499 0.013903 TRUE {=NORMSDIST(R1:R49)} 0.017864420562817 0.017864 TRUE {=NORMSDIST(R1:R49)} 0.022750131948179 0.022750 TRUE {=NORMSDIST(R1:R49)} 0.028716559816002 0.028717 TRUE {=NORMSDIST(R1:R49)} 0.035930319112926 0.035930 TRUE {=NORMSDIST(R1:R49)} 0.044565462758543 0.044565 TRUE {=NORMSDIST(R1:R49)} 0.054799291699558 0.054799 TRUE {=NORMSDIST(R1:R49)} 0.066807201268858 0.066807 TRUE {=NORMSDIST(R1:R49)} 0.080756659233771 0.080757 TRUE {=NORMSDIST(R1:R49)} 0.09680048458561 0.096800 TRUE {=NORMSDIST(R1:R49)} 0.115069670221708 0.115070 TRUE {=NORMSDIST(R1:R49)} 0.135666060946383 0.135666 TRUE {=NORMSDIST(R1:R49)} 0.158655253931457 0.158655 TRUE {=NORMSDIST(R1:R49)} 0.184060125346759 0.18406012534676 TRUE {=NORMSDIST(R1:R49)} 0.211855398583397 0.211855398583397 TRUE {=NORMSDIST(R1:R49)} 0.241963652223073 0.241963652223073 TRUE {=NORMSDIST(R1:R49)} 0.274253117750074 0.274253117750074 TRUE {=NORMSDIST(R1:R49)} 0.308537538725987 0.308537538725987 TRUE {=NORMSDIST(R1:R49)} 0.344578258389676 0.344578258389676 TRUE {=NORMSDIST(R1:R49)} 0.382088577811047 0.382088577811047 TRUE {=NORMSDIST(R1:R49)} 0.420740290560897 0.420740290560897 TRUE {=NORMSDIST(R1:R49)} 0.460172162722971 0.460172162722971 TRUE {=NORMSDIST(R1:R49)} 0.5 0.5 TRUE {=NORMSDIST(R1:R49)} 0.539827837277029 0.539827837277029 TRUE {=NORMSDIST(R1:R49)} 0.579259709439103 0.579259709439103 TRUE {=NORMSDIST(R1:R49)} 0.617911422188953 0.617911422188953 TRUE {=NORMSDIST(R1:R49)}