ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Calculated Field
2
Solve OrderFieldFormula
3
4
Calculated Item
5
Solve OrderItemFormula
6
1Cars=Car +'Taxi/Private hire car'
7
2Bus='Minibus (8 - 16 passenger seats)'+'Bus or coach (17 or more pass seats)'
8
3Van='Goods 7.5 tonnes mgw and over'+'Goods over 3.5t. and under 7.5t'
9
10
11
Note:
When a cell is updated by more than one formula,
12
the value is set by the formula with the last solve order.
13
14
To change the solve order for multiple calculated items or fields,
15
on the Options tab, in the Calculations group, click Fields, Items, & Sets, and then click Solve Order.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100