Sigma function

[HWK]

Hello, I'm trying to type the following formula, but not really sure how to deal with sigma summation.

The data for qx and x are available.

Any help would be appreciated.

[shg]

Welcome to the forum.

One way:

Row\Col	A	B	C	D
1	Bi	x	q(x)
2	0.1	0.050	-0.88043	C2: =1 - EXP(SUMPRODUCT($A$2:$A$4 * B2^{0,1,2}))
3	0.2	0.100	-0.94644
4	0.3	0.150	-1.02081
5		0.200	-1.10434
6		0.250	-1.19789
7		0.300	-1.30251
8		0.350	-1.41935
9		0.400	-1.54976
10		0.450	-1.69527
11		0.500	-1.85765
12		0.550	-2.03891
13		0.600	-2.24138
14		0.650	-2.46773
15		0.700	-2.72103
16		0.750	-3.00483
17		0.800	-3.32322
18		0.850	-3.68094
19		0.900	-4.0835
20		0.950	-4.53726
21		1.000	-5.04965

[HWK]

Thanks. However, when I try to apply the formula mentioned above it says error and the zero in this part - B2^{0,1,2} is highlighted. Does it work well in your spreadsheet?

As far as I understand, there are arrays in SUMPRODUCT function, which are separated by commas and excel takes whole $A$2:$A$4 * B2^{0, thing as first array. Maybe that's the problem.

[XOR LX]

Hi.

I believe in your version of Excel such array constants use "\" as the separator, i.e. {0\1\2}.

Regards

[HWK]

Thanks! It finally worked. The separator was ";" though.