A B C D E F G H I J K L M N
2
3 Ev
4
5 Category:
6 Family:
7 Arguments:
8 Meaning:
9 Description:
10 Data:   11.00
11 fred
12
13
14
15 Single Cell References
16
17 G10   11
18 =G11 fred
19
20
21 With Defaults
22 Default Options
23 =G11   99   fred
24     99     99
25
26 1 Use the DefaultValue if Textstring is an error (eg #NUM!, #NA etc). (Normal behaviour: throw an error)
27 2 Use the DefaultValue if the reference in Textstring is invalid (ie not pointing to anything). (Normal behaviour: throw an error)
28 4 Use the DefaultValue if the reference in textstring is an error (ie the thing its pointing at is an error). (Normal behaviour: throw an error)
29 These are options are additive eg 1+2 etc.
30
31
32 Multi-Cell References & Array Usage
33
34 G10:G11   11
35 fred
36
37 Range Names
38
39 Normal (Global) Name EVName fred
40
41 Local Name ie Ev!EvLocalName EVLocalName   11
42
43 Multiple Range Usage (additive)
44 Range1 Range2
45 Range Names Range1   23 Data:   22   1
46 Range2   35   33   2
47     47   44   3
48        
49
50 This usage is useful for adding ranges together by name.
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80