Numeric Operators In AFC
The supported numeric operators are shown by example below. The examples also show how operator precedence is taken into account.
| A | B | C | D | E |
2 | 3.0 | =C2+D2 | 1.0 | 2.0 | |
3 | 12.0 | =C3+D3+E3 | 5.0 | 4.0 | 3.0 | |
4 | 6.6 | ... | 1.1 | 2.2 | 3.3 | |
3 | 12.0 | ... | 5.0 | 4.0 | 3.0 | |
| A | B | C | D | E |
6 | 2.0 | =C6-D6 | 3.0 | 1.0 | |
7 | 1.0 | =C7-D7-E7 | 5.0 | 3.0 | 1.0 | |
8 | -4.4 | ... | 1.1 | 2.2 | 3.3 | |
7 | 1.0 | ... | 5.0 | 3.0 | 1.0 | |
| A | B | C | D |
10 | 35.0 | =C10*D10 | 5.0 | 7.0 | |
11 | 0.2 | ... | 0.4 | 0.5 | |
10 | 35.0 | ... | 5.0 | 7.0 | |
| A | B | C | D | E |
16 | 2.5 | =C16/D16 | 10.0 | 4.0 | |
17 | 8.0 | =C17-D17/E17 | 10.0 | 4.0 | 2.0 | |
18 | 7.0 | ... | 10.0 | 9.0 | 3.0 | |
17 | 8.0 | ... | 10.0 | 4.0 | 2.0 | |
19 | 9.666666666666666 | ... | 10.0 | 1.0 | 3.0 | |
| A | B | C | D |
20 | !+Inf/AE | =C20/D20 | 1.0 | 0.0 | | Excel says: #DIV/0! |
| A | B | C | D |
22 | -10.0 | =-C22 | 10.0 | |
23 | -2.0 | =-C23--D23 | 5.0 | 3.0 | |
24 | -1.0 | ... | -3.0 | -4.0 | |
23 | -2.0 | ... | 5.0 | 3.0 | |
These are operators that return a boolean value, which is either the number 1 (true) or 0 (false) internally, shown by example:
| A | B | C | D |
2 | false | =C2=D2 | 10.0 | 20.0 | |
3 | false | ... | 50.0 | 40.0 | |
4 | true | ... | 50.0 | 50.0 | |
5 | false | ... | 10.0 | | |
6 | false | ... | | 10.0 | |
7 | false | ... | -10.0 | | |
8 | false | ... | | -10.0 | |
| A | B | C | D |
10 | true | =C10<>D10 | 10.0 | 20.0 | |
11 | true | ... | 50.0 | 40.0 | |
12 | false | ... | 50.0 | 50.0 | |
13 | true | ... | 10.0 | | |
14 | true | ... | | 10.0 | |
15 | true | ... | -10.0 | | |
16 | true | ... | | -10.0 | |
| A | B | C | D |
18 | false | =C18>D18 | 10.0 | 20.0 | |
19 | true | ... | 50.0 | 40.0 | |
20 | false | ... | 50.0 | 50.0 | |
21 | true | ... | 10.0 | | |
22 | false | ... | | 10.0 | |
23 | false | ... | -10.0 | | |
24 | true | ... | | -10.0 | |
| A | B | C | D |
26 | true | =C26<D26 | 10.0 | 20.0 | |
27 | false | ... | 50.0 | 40.0 | |
28 | false | ... | 50.0 | 50.0 | |
29 | false | ... | 10.0 | | |
30 | true | ... | | 10.0 | |
31 | true | ... | -10.0 | | |
32 | false | ... | | -10.0 | |
| A | B | C | D |
34 | false | =C34>=D34 | 10.0 | 20.0 | |
35 | true | ... | 50.0 | 40.0 | |
36 | true | ... | 50.0 | 50.0 | |
37 | true | ... | 10.0 | | |
38 | false | ... | | 10.0 | |
39 | false | ... | -10.0 | | |
40 | true | ... | | -10.0 | |
| A | B | C | D |
42 | true | =C42<=D42 | 10.0 | 20.0 | |
43 | false | ... | 50.0 | 40.0 | |
44 | true | ... | 50.0 | 50.0 | |
45 | false | ... | 10.0 | | |
46 | true | ... | | 10.0 | |
47 | true | ... | -10.0 | | |
48 | false | ... | | -10.0 | |