AFC - Abacus Formula Compiler for Java

Home | Quick Start | Documentation | Download | Support | Contribute

Home > Documentation > Reference >

Booleans In AFC

Boolean Functions

The supported boolean values and functions, shown by example (note that the functions AND and OR are range functions):

Constant Values

	A	B	C
2	true	=true
3	false	=false
4	true	=C4	true
5	false	...	false

SEJ treats booleans as numbers

	A	B	C
7	true	=(C7 = 0.0)	false		Excel says: false
8	true	=(C8 = 1.0)	true		Excel says: false

NOT

	A	B	C	D
10	false	=NOT( C10 )	true
11	true	...	false
12	false	=NOT( (C12 <> D12) )	10.0	20.0
13	false	...	50.0	40.0
14	true	...	50.0	50.0
15	true	=NOT( (C15 = D15) )	10.0	20.0
16	true	...	50.0	40.0
17	false	...	50.0	50.0

AND

	A	B	C	D	E	F
19	true	=AND( C19, D19 )	true	true
20	false	...	true	false
21	false	...	false	true
22	false	...	false	false
23	true	=AND( (C23 = D23), (E23 = F23) )	10.0	10.0	20.0	20.0
24	false	...	5.0	10.0	20.0	20.0
25	false	...	5.0	10.0	15.0	20.0
26	false	...	10.0	10.0	15.0	20.0

OR

	A	B	C	D	E	F
28	true	=OR( C28, D28 )	true	true
29	true	...	true	false
30	true	...	false	true
31	false	...	false	false
32	true	=OR( (C32 = D32), (E32 = F32) )	10.0	10.0	20.0	20.0
33	true	...	5.0	10.0	20.0	20.0
34	false	...	5.0	10.0	15.0	20.0
35	true	...	10.0	10.0	15.0	20.0

Combinations, range arguments

	A	B	C	D	E
37	true	=OR( AND( C37:D37 ), E37 )	true	true	true
38	true	...	true	true	false
39	true	...	true	false	true
40	false	...	true	false	false
41	true	...	false	true	true
42	false	...	false	true	false
43	true	...	false	false	true
44	false	...	false	false	false
46	true	=AND( OR( C46:D46 ), E46 )	true	true	true
47	false	...	true	true	false
48	true	...	true	false	true
49	false	...	true	false	false
50	true	...	false	true	true
51	false	...	false	true	false
52	false	...	false	false	true
53	false	...	false	false	false

`IF` Function

IF is supported for numeric and string return values, shown by example:

Constant condition

	A	B
2	100.0	=IF( true, 100.0, 10.0 )
3	10.0	=IF( false, 100.0, 10.0 )

Reference condition

	A	B	C
5	100.0	=IF( C5, 100.0, 10.0 )	true
6	10.0	...	false

Return reference

	A	B	C	D	E
8	100.0	=IF( C8, D8, E8 )	true	100.0	10.0
9	10.0	...	false	100.0	10.0

Return expression

	A	B	C	D	E
11	110.0	=IF( C11, (D11 + E11), (D11 - E11) )	true	100.0	10.0
12	90.0	...	false	100.0	10.0

Return string

	A	B	C	D	E
14	yes	=IF( C14, D14, E14 )	true	yes	no
15	no	...	false	yes	no

Comparison condition

	A	B	C	D
17	10.0	=IF( (C17 > D17), 100.0, 10.0 )	10.0	20.0
18	100.0	...	50.0	40.0
19	10.0	...	50.0	50.0
20	10.0	...	A	B
21	100.0	...	A	10.0
22	10.0	...	10.0	B
24	100.0	=IF( (C24 < D24), 100.0, 10.0 )	10.0	20.0
25	10.0	...	50.0	40.0
26	10.0	...	50.0	50.0
27	100.0	...	A	B
28	10.0	...	A	10.0
29	100.0	...	10.0	B
31	10.0	=IF( (C31 >= D31), 100.0, 10.0 )	10.0	20.0
32	100.0	...	50.0	40.0
33	100.0	...	50.0	50.0
34	10.0	...	A	B
35	100.0	...	A	10.0
36	10.0	...	10.0	B
38	100.0	=IF( (C38 <= D38), 100.0, 10.0 )	10.0	20.0
39	10.0	...	50.0	40.0
40	100.0	...	50.0	50.0
41	100.0	...	A	B
42	10.0	...	A	10.0
43	100.0	...	10.0	B
45	10.0	=IF( (C45 = D45), 100.0, 10.0 )	10.0	20.0
46	10.0	...	50.0	40.0
47	100.0	...	50.0	50.0
48	10.0	...	A	B
49	10.0	...	A	10.0
50	10.0	...	10.0	B
52	100.0	=IF( (C52 <> D52), 100.0, 10.0 )	10.0	20.0
53	100.0	...	50.0	40.0
54	10.0	...	50.0	50.0
55	100.0	...	A	B
56	100.0	...	A	10.0
57	100.0	...	10.0	B

Boolean operator condition

	A	B	C	D	E	F
59	10.0	=IF( NOT( (C59 <> D59) ), 100.0, 10.0 )	10.0	20.0
60	10.0	...	50.0	40.0
61	100.0	...	50.0	50.0
63	100.0	=IF( NOT( (C63 = D63) ), 100.0, 10.0 )	10.0	20.0
64	100.0	...	50.0	40.0
65	10.0	...	50.0	50.0
67	100.0	=IF( AND( (C67 = D67), (E67 = F67) ), 100.0, 10.0 )	10.0	10.0	20.0	20.0
68	10.0	...	5.0	10.0	20.0	20.0
69	10.0	...	5.0	10.0	15.0	20.0
70	10.0	...	10.0	10.0	15.0	20.0
72	100.0	=IF( OR( (C72 = D72), (E72 = F72) ), 100.0, 10.0 )	10.0	10.0	20.0	20.0
73	100.0	...	5.0	10.0	20.0	20.0
74	10.0	...	5.0	10.0	15.0	20.0
75	100.0	...	10.0	10.0	15.0	20.0
77	100.0	=IF( OR( AND( C77:D77 ), E77 ), 100.0, 10.0 )	true	true	true
78	100.0	...	true	true	false
79	100.0	...	true	false	true
80	10.0	...	true	false	false
81	100.0	...	false	true	true
82	10.0	...	false	true	false
83	100.0	...	false	false	true
84	10.0	...	false	false	false
86	100.0	=IF( AND( OR( C86:D86 ), E86 ), 100.0, 10.0 )	true	true	true
87	10.0	...	true	true	false
88	100.0	...	true	false	true
89	10.0	...	true	false	false
90	100.0	...	false	true	true
91	10.0	...	false	true	false
92	10.0	...	false	false	true
93	10.0	...	false	false	false

Copyright © 2005-2009 by Abacus Research AG. All rights reserved.