AFC - Abacus Formula Compiler for Java

Conversion Functions In AFC

Conversion Functions

The supported conversion functions are shown by example below:

VALUE (does not support blanks!)
ABC
2123.0=VALUE( C2 )123
3123.0... 123
4123.55...123.55
5-23.0... -23
61.0E8...100,000,000
70.2...20%
81.234567E9...1,234.567e6
9-1.2345E-6...-12345e-10
10-1.23456E-7...-123,456E-12
1112.345...12.345
1235981.0...7/5/1998
1335981.0...7/5/98
1435981.50902777778...7/5/1998 12:13
1535981.50918981482...7/5/98 12:13:14
160.5090277777777777...12:13
170.5091898148148148...12:13:14
180.009027777777777779...0:13
190.009189814814814814...0:13:14
2035981.50902777778...7/5/1998 12:13 PM
2135981.50918981482...7/5/98 12:13:14 PM
220.5090277777777777...12:13 PM
230.5091898148148148...12:13:14 PM
240.5090277777777777...0:13 PM
250.5091898148148148...0:13:14 PM
260.009027777777777779...12:13 AM
270.009189814814814814...12:13:14 AM
280.009027777777777779...0:13 AM
290.009189814814814814...0:13:14 AM
3010959.0...1/1/30
3147483.0...12/31/29
3235981.0...1998/7/5
3335981.50902777778...1998/7/5 12:13
3435981.50918981482...1998/7/5 12:13:14
3535981.0...1998-7-5
3635981.50902777778...1998-7-5 12:13
3735981.50918981482...1998-7-5 12:13:14
38!FE...This is not a numberExcel says: #VALUE!

N (does not support blanks!)
ABC
4012.345=N( C40 )12.345
410.0...12345
4239083.0...39083.0
430.0...1/1/2007
441.0...true
450.0...false

T (does not support blanks!)
ABC
47AaBbCcDd=T( C47 )AaBbCcDd
48АаБбВвГгДд...АаБбВвГгДд
49...123.45
50123.45...123.45
51...39083.0
521/1/2007...1/1/2007
53...true
54...false

TEXT (does not support blanks!)
ABCD
560=TEXT( C56, D56 )0.0@
5799999999999...9.99999999994999E10@
581E+11...9.99999999995E10@
590.000000009...9.0E-9@
609E-09...9.000001E-9@
617.77778E-05...7.77777777777777E-5@
620.000777778...7.77777777777777E-4@
630.007777778...0.00777777777777777@
640.077777778...0.0777777777777777@
650.777777778...0.777777777777777@
667.777777778...7.77777777777777@
6777.77777778...77.7777777777777@
68777.7777778...777.777777777777@
697777.777778...7777.77777777777@
7077777.77778...77777.7777777777@
71777777.7778...777777.777777777@
727777777.778...7777777.77777777@
7377777777.78...7.77777777777777E7@
74777777777.8...7.77777777777777E8@
757777777778...7.77777777777777E9@
7677777777778...7.77777777777777E10@
777.77778E+11...7.77777777777777E11@
787.77778E+12...7.77777777777777E12@
797.77778E+13...7.77777777777777E13@
807.77778E+14...7.77777777777777E14@
81-777777777.8...-7.77777777777777E8@
82-7777777778...-7.77777777777777E9@
83-77777777778...-7.77777777777777E10@
84-7.77778E+11...-7.77777777777777E11@
850.000000001...1.0E-9@
860.000000011...1.1E-8@
870.000000111...1.11E-7@
880.000001111...1.111E-6@
890.000011111...1.1111E-5@
900.000111111...1.11111E-4@
910.001111111...0.001111111@
920.011111111...0.011111111@
930.111111111...0.111111111@
941E-11...1.0E-11@
951.1E-10...1.1E-10@
961.01E-09...1.01E-9@
971.101E-08...1.101E-8@
981.1101E-07...1.1101E-7@
991.11101E-06...1.11101E-6@
1001.1111E-05...1.111101E-5@
1010.000111111...1.1111101E-4@
1020.001111111...0.00111111101@
1030.011111111...0.01111111101@
1040.111111111...0.11111111101@
1059.9E-10...9.9E-10@
1061.99E-09...1.99E-9@
1071.199E-08...1.199E-8@
1081.1199E-07...1.1199E-7@
1091.11199E-06...1.11199E-6@
1101.1112E-05...1.111199E-5@
1110.000111112...1.1111199E-4@
1120.001111112...0.00111111199@
1130.011111112...0.01111111199@
1140.111111112...0.11111111199@
115AaBbCcDd...AaBbCcDd@
116АаБбВвГгДд...АаБбВвГгДд@

FIXED
ABCDE
118123.00=FIXED( C118 )123.0
11912.340=FIXED( C119, D119 )12.343.0
12012,345.340...12345.343.0
121123,456,789.123...1.23456789123456E83.0
12212,300...12345.34-2.0
12312345.340=FIXED( C123, D123, E123 )12345.343.0true
12412,345.340...12345.343.0false
1251,234,567,891,234.56...1.23456789123456E122.0false
126123,456,789,123,400.00...1.234567891234E142.0false
1271,234.6=FIXED( C127, D127 )1234.5671.0
128-1,230...-1234.567-1.0
1291230=FIXED( C129, D129, E129 )1234.567-1.0true
130-1230...-1234.567-1.0true

DOLLAR
ABCD
132$123.00=DOLLAR( C132 )123.0
133($1,234.57)...-1234.567
135($1,000)=DOLLAR( C135, D135 )-1234.5678-3.0
136($1,234.568)...-1234.56783.0

CHAR
ABC
138A=CHAR( C138 )65.0
1398...56.0
140{...123.0
141}...125.0
142d...100.0
143...127.0
144¬...172.0
145!FE...0.0Excel says: #VALUE!
146!FE...256.0Excel says: #VALUE!
147!FE...1200.0Excel says: #VALUE!
148!FE...2050.0Excel says: #VALUE!
149!FE...-1.0Excel says: #VALUE!

CODE
ABC
15165.0=CODE( C151 )A
15297.0...a
15397.0...aA
15449.0...1.0
15549.0...12.0
156127.0...
157104.0...h
15863.0...ё
159246.0...ö

DATEVALUE
ABC
16135981.0=DATEVALUE( C161 )7/5/1998
16235981.0...7/5/98
16335981.0...7/5/1998 12:13
16435981.0...7/5/98 12:13:14
1650.0...12:13
1660.0...12:13:14
16735981.0...7/5/1998 12:13 PM
16835981.0...7/5/98 12:13:14 PM
16910959.0...1/1/30
17047483.0...12/31/29
17135981.0...1998/7/5
17235981.0...1998/7/5 12:13
17335981.0...1998/7/5 12:13:14
17435981.0...1998-7-5
17535981.0...1998-7-5 12:13
17635981.0...1998-7-5 12:13:14
17739106.0...1/24/2007
17839106.0...1/24/07
179!FE...1-7-4Excel says: 37993.0
180!FE...01-07-04Excel says: 37993.0
181!FE...01-07-2004Excel says: 37993.0
18237993.0...01/07/2004
183!FE...01 07 2004Excel says: #VALUE!
18437076.0...2001/7/4
18537076.0...2001-7-4
18637076.0...2001-07-04
187!FE...6/6/1996 12:00:00 AMExcel says: 35222.0
188!FE...January 24, 2007Excel says: 39106.0
189!FE...Jan 24, 2007Excel says: 39106.0
190!FE...Jan 24, 07Excel says: 39106.0
191!FE...Jan , 24, 07Excel says: 39106.0
192!FE...Jan 24,07Excel says: #VALUE!
193!FE...Jan - 24, 07Excel says: 39106.0
194!FE...09-AUG 2008Excel says: 39669.0
195!FE...Jan 24Excel says: 39106.0
196!FE...24 JanExcel says: 39106.0
197!FE...24 Jan 12: 13:14Excel says: 39106.0
198!FE...AUG-10Excel says: 39304.0
199!FE...AUG 10Excel says: 39304.0
200!FE...10-AUGExcel says: 39304.0
201!FE...10 - AUG-07Excel says: 39304.0
202!FE...AUGUST 06Excel says: 39300.0
203!FE...AUGUST 2006Excel says: 38930.0
204!FE...FEB 30Excel says: 10990.0
205!FE...09-AUGUST-2008Excel says: 39669.0
206!FE...09/AUGUST-2008Excel says: 39669.0
207!FE...09 AUGUST 2008Excel says: 39669.0
208!FE...January 24Excel says: 39106.0
209!FE...2007Excel says: #VALUE!
210!FE...37/1Excel says: #VALUE!
211!FE...1-37Excel says: 13516.0
212!FE...1/37Excel says: 13516.0
213!FE...1/1937Excel says: 13516.0
214!FE...1/8Excel says: 39090.0
21539145...2/32/2007Excel says: #VALUE!
216!FE...1/2008Excel says: 39448.0
21739090.0...1/8/2007
218!FE...09 AUGUST, 2008Excel says: #VALUE!
219!FE...2009 AUGUST 08Excel says: #VALUE!
220!FE...AUGUST 08 2009Excel says: #VALUE!
221!FE...2009 08 AUGExcel says: #VALUE!
222!FE...08.10.97Excel says: #VALUE!
223!FE...01.10.01Excel says: #VALUE!
22435981...7/5/98 12:21:1fExcel says: #VALUE!
225!FE...08.10.1997Excel says: #VALUE!

TIMEVALUE
ABC
2270.5090277777781012=TIMEVALUE( C227 )7/5/1998 12: 13
2280.5091898148166365...7/5/98 12:13:14
2290.0...7/5/1998
2300.5090277777777777...12:13
2310.5091898148148148...12:13:14
2320.009027777777777779...0:13
2330.009189814814814814...0:13:14
2340.5090277777781012...7/5/1998 12:13 PM
2350.5091898148166365...7/5/98 12:13:14 PM
2360.5090277777777777...12:13 PM
2370.5091898148148148...12:13:14 PM
2380.5090277777777777...0:13 PM
2390.5091898148148148...0:13:14 PM
2400.009027777777777779...12:13 AM
2410.009189814814814814...12:13:14 AM
2420.009027777777777779...0:13 AM
2430.009189814814814814...0:13:14 AM
2440.0...6/6/1996 12:00:00 AM
2450.5090277777781012...1998/7/5 12:13
2460.5091898148166365...1998/7/5 12:13:14
2470.5090277777781012...1998-7-5 12:13
2480.5091898148166365...1998-7-5 12:13:14
2490.050694444444444375...49:13

ROMAN
ABCD
2I=ROMAN( C2 )1.0
3II...2.2
4XII...12.0
5IX...9.0
6XI...11.0
7XL...40.0
8XLIX...49.0
9XCIX...99.0
10C...100.0
11CLIX...159.0
12MCXXIII...1123.0
13MMMCMXCIX...3999.0
14CDXCIX...499.0
15CDXCIX=ROMAN( C15, D15 )499.00.0
16LDVLIV...499.01.0
17XDIX...499.02.0
18VDIV...499.03.0
19ID...499.04.0
20MMXIII...2013.00.0
21!FE=ROMAN( C21 )4000.0Excel says: #VALUE!