B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
Choose Function
9
10
Year
Index
Sales (A)
Sales (B)
Sales (A)
Sales (B)
11
2001
1
23200
50000
12
2002
2
74332
34332
13
2003
3
44566
94344
14
2004
4
55454
124553
15
2005
5
155545
60393
16
17
Index
18
1
2
3
4
5
19
20
21
22
23
24
25
26
Choose Function return a value from the list of value arguments. Use CHOOSE to select one of up to 29 values based on the index number.
27
28
Change the index number of the Year and see how the Sales change.
29
30
This example is contributed by www.xlmacros.com
31
32
33
34
Copyright.
Anthony's VBA Page.
35
36
37
38
39
40
41
42
43
44
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.