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

# Numeric Functions In AFC

### Numeric Functions

The supported numeric functions are shown by example below:

##### ABS
 A B C 2 1.0 =ABS( C2 ) -1.0 3 0.0 ... 0.0 4 1.0 ... 1.0 5 1.9999 ... -1.9999 6 1.9999 ... 1.9999 7 0.0 ... false 8 1.0 ... true 9 3.0 ... -3.0 10 4.0 ... -4.0

##### ACOS
 A B C 12 3.141592653589793 =ACOS( C12 ) -1.0 13 3.127450400112281 ... -0.9999 14 2.0943951023931957 ... -0.5 15 1.5708963267950633 ... -1.0E-4 16 1.5707963267948966 ... 0.0 17 1.5706963267947298 ... 1.0E-4 18 1.0471975511965976 ... 0.5 19 0.014142253477511968 ... 0.9999 20 0.0 ... 1.0 21 !NaN/FE ... -1.0001 Excel says: #NUM! 22 !NaN/FE ... 1.0001 Excel says: #NUM!

##### ACOSH
 A B C 24 0.0 =ACOSH( C24 ) 1.0 25 1.3169578969248166 ... 2.0 26 1.762747174039086 ... 3.0 27 2.1615809409653055 ... 4.4 28 3.0630757460972857 ... 10.72 29 3.705377831216652 ... 20.345 30 5.298292365610485 ... 100.0 31 7.600902209541989 ... 1000.0 32 9.903487550036129 ... 10000.0 33 12.206072645505174 ... 100000.0 34 14.508657738523969 ... 1000000.0 35 !NaN/FE ... 0.98 Excel says: #NUM! 36 !NaN/FE ... -1.0 Excel says: #NUM!

##### ASIN
 A B C 38 -1.5707963267948966 =ASIN( C38 ) -1.0 39 -1.5566540733173846 ... -0.9999 40 -0.5235987755982989 ... -0.5 41 -1.0000000016666668E-4 ... -1.0E-4 42 0.0 ... 0.0 43 1.0000000016666668E-4 ... 1.0E-4 44 0.5235987755982989 ... 0.5 45 1.5566540733173846 ... 0.9999 46 1.5707963267948966 ... 1.0 47 !NaN/FE ... -1.0001 Excel says: #NUM! 48 !NaN/FE ... 1.0001 Excel says: #NUM!

##### ASINH
 A B C 50 0.0 =ASINH( C50 ) 0.0 51 0.48121182505960347 ... 0.5 52 -0.48121182505960336 ... -0.5 53 1.4436354751788103 ... 2.0 54 -1.4436354751788099 ... -2.0 55 1.8184464592320668 ... 3.0 56 2.3124383412727525 ... 5.0 57 2.99822295029797 ... 10.0 58 5.298342365610589 ... 100.0 59 12.206072645555174 ... 100000.0 60 -12.206073762186564 ... -100000.0

##### ATAN
 A B C 62 -1.5707963257948967 =ATAN( C62 ) -1.0E9 63 -1.5697963271282298 ... -1000.0 64 -0.7853981633974483 ... -1.0 65 -0.09966865249116204 ... -0.1 66 -9.999996666668668E-4 ... -0.0010 67 0.0 ... 0.0 68 9.999996666668668E-4 ... 0.0010 69 0.09966865249116204 ... 0.1 70 0.7853981633974483 ... 1.0 71 1.5697963271282298 ... 1000.0 72 1.5707963257948967 ... 1.0E9

##### ATANH
 A B C 74 0.0 =ATANH( C74 ) 0.0 75 0.10033534773107562 ... 0.1 76 -0.10033534773107562 ... -0.1 77 0.5493061443340549 ... 0.5 78 -0.5493061443340549 ... -0.5 79 0.8673005276940532 ... 0.7 80 -0.8673005276940531 ... -0.7 81 !+Inf/FE ... 1.0 Excel says: #NUM! 82 !-Inf/FE ... -1.0 Excel says: #NUM! 83 !NaN/FE ... 2.0 Excel says: #NUM! 84 !NaN/FE ... 1000.0 Excel says: #NUM!

##### ATAN2
 A B C D 86 -2.356194490192345 =ATAN2( C86, D86 ) -1.0 -1.0 87 -0.7853981633974483 ... 1.0 -1.0 88 -1.5707963267948966 ... 0.0 -1.0 89 2.356194490192345 ... -1.0 1.0 90 0.7853981633974483 ... 1.0 1.0 91 1.5707963267948966 ... 0.0 1.0 92 3.141592653589793 ... -1.0 0.0 93 0.0 ... 1.0 0.0 94 0.0 ... 0.0 0.0 Excel says: #DIV/0! 95 -9.999996666668668E-4 ... 1000.0 -1.0 96 9.999996666668668E-4 ... 1000.0 1.0

##### GEOMEAN
 A B C D E F 98 1.0 =GEOMEAN( C98, D98 ) 1.0 1.0 99 3.0 ... 3.0 3.0 100 2.449489742783178 ... 2.0 3.0 101 12.0 ... 2.0 72.0 102 1.7211914478058505 ... 1.25 2.37 103 !FE ... 0.0 1.0 Excel says: #NUM! 104 !FE ... 1.0 -1.0 Excel says: #NUM! 105 !FE ... -2.0 -3.0 Excel says: #NUM! 107 5.0 =GEOMEAN( C107, D107, E107:F107 ) 5.0 5.0 5.0 5.0 108 3.0 ... 9.0 3.0 3.0 1.0 109 4.949232003839765 ... 50.0 2.0 3.0 2.0

##### HARMEAN
 A B C D E F 111 4.0 =HARMEAN( C111, D111 ) 4.0 4.0 112 1.0 ... 1.0 1.0 113 3.2 ... 2.0 8.0 114 2.6666666666666665 ... 2.0 4.0 115 1.6367403314917126 ... 1.25 2.37 116 !FE ... 0.0 1.0 Excel says: #NUM! 117 !FE ... 1.0 -1.0 Excel says: #NUM! 118 !FE ... 0.0 -1.0 Excel says: #NUM! 120 3.2 =HARMEAN( C120, D120, E120:F120 ) 2.0 2.0 8.0 8.0 121 2.206896551724138 ... 16.0 4.0 2.0 1.0 122 2.6666666666666665 ... 4.0 2.0 4.0 2.0

##### PERMUT
 A B C D 124 2.0 =PERMUT( C124, D124 ) 2.0 1.0 125 6.0 ... 3.0 3.0 126 1.0 ... 1.1 1.3 127 2520.0 ... 7.0 5.0 128 6.0 ... 3.4 2.1 129 !FE ... 0.0 1.0 Excel says: #NUM! 130 1.0 ... 0.0 0.0 131 !FE ... 1.0 -1.0 Excel says: #NUM! 132 !FE ... -1.0 1.0 Excel says: #NUM! 133 !FE ... 0.0 -1.0 Excel says: #NUM!

##### COS
 A B C 144 0.9367521275331392 =COS( C144 ) -1000000.0 145 -0.9999999999730151 ... -3.1416 146 -0.9999999999964793 ... -3.14159 147 0.9950041652780258 ... -0.1 148 0.9999995000000417 ... -0.0010 149 1.0 ... 0.0 150 0.9999995000000417 ... 0.0010 151 0.9950041652780258 ... 0.1 152 -0.9999999999964793 ... 3.14159 153 -0.9999999999730151 ... 3.1416 154 0.9367521275331392 ... 1000000.0

##### COSH
 A B C 156 1.0 =COSH( C156 ) 0.0 157 1.5430806348152437 ... 1.0 158 3.7621956910836314 ... 2.0 159 3.7621956910836314 ... -2.0 160 1.3440585709080678E43 ... 100.0 161 1.8865101504649698E260 ... 600.0 162 1.8865101504649698E260 ... -600.0

##### SIGN
 A B C 164 0.0 =SIGN( C164 ) 0.0 165 1.0 ... 1.0 166 1.0 ... 2.0 167 -1.0 ... -1.0 168 -1.0 ... -2.0 169 1.0 ... 10000.0 170 -1.0 ... -10000.0

##### SIN
 A B C 172 0.3499935021713079 =SIN( C172 ) -1000000.0 173 7.346410206643537E-6 ... -3.1416 174 -2.6535897933527804E-6 ... -3.14159 175 -0.09983341664682815 ... -0.1 176 -9.999998333333417E-4 ... -0.0010 177 0.0 ... 0.0 178 9.999998333333417E-4 ... 0.0010 179 0.09983341664682815 ... 0.1 180 2.6535897933527804E-6 ... 3.14159 181 -7.346410206643537E-6 ... 3.1416 182 -0.3499935021713079 ... 1000000.0

##### SINH
 A B C 184 0.0 =SINH( C184 ) 0.0 185 1.1752011936438014 ... 1.0 186 11.53029203041011 ... 3.14 187 -1.1752011936438014 ... -1.0 188 -74.20321057778875 ... -5.0 189 1.3440585709080678E43 ... 100.0 190 3.6129868840628745E86 ... 200.0 191 -3.6129868840628745E86 ... -200.0 192 1.5199748986808874E43 ... 100.123 193 4.109203730777486E307 ... 709.0 194 (sinh 710) ... 710.0 Excel says: #NUM!

##### TAN
 A B C 196 0.37362445398761723 =TAN( C196 ) -1000000.0 197 -7.346410206841779E-6 ... -3.1416 198 2.653589793362123E-6 ... -3.14159 199 -0.10033467208545055 ... -0.1 200 -0.0010000003333334668 ... -0.0010 201 0.0 ... 0.0 202 0.0010000003333334668 ... 0.0010 203 0.10033467208545055 ... 0.1 204 -2.653589793362123E-6 ... 3.14159 205 7.346410206841779E-6 ... 3.1416 206 -0.37362445398761723 ... 1000000.0

##### TANH
 A B C 208 0.0 =TANH( C208 ) 0.0 209 0.7615941559557649 ... 1.0 210 -0.7615941559557649 ... -1.0 211 0.9999999958776926 ... 10.0 212 -0.9999999958776926 ... -10.0 213 1.0 ... 100.0 214 -1.0 ... -100.0 215 1.0 ... 10000.0 216 -1.0 ... -1000.0 217 0.9972829600991422 ... 3.3 218 -0.9972829600991422 ... -3.3

##### DEGREES
 A B C 220 -5.7295779513082325E7 =DEGREES( C220 ) -1000000.0 221 -180.00042091829943 ... -3.1416 222 -179.99469134034814 ... -3.1415 223 -5.729577951308233 ... -0.1 224 -0.057295779513082325 ... -0.0010 225 0.0 ... 0.0 226 0.057295779513082325 ... 0.0010 227 5.729577951308233 ... 0.1 228 179.99469134034814 ... 3.1415 229 180.00042091829943 ... 3.1416 230 5.7295779513082325E7 ... 1000000.0

 A B C 232 -17453.292519943294 =RADIANS( C232 ) -1000000.0 233 -6.283185307179586 ... -360.0 234 -3.141592653589793 ... -180.0 235 -0.5235987755982988 ... -30.0 236 -0.0017453292519943296 ... -0.1 237 0.0 ... 0.0 238 0.0017453292519943296 ... 0.1 239 0.5235987755982988 ... 30.0 240 3.141592653589793 ... 180.0 241 6.283185307179586 ... 360.0 242 17453.292519943294 ... 1000000.0

##### PI
 A B 244 3.141592653589793 =PI()

##### CEILING
 A B C D 246 0.0 =CEILING( C246, D246 ) 0.0 0.03 247 0.03 ... 0.02999 0.03 248 0.03 ... 0.03 0.03 249 0.06 ... 0.03001 0.03 250 640000.0 ... 512000.1 128000.0 251 0.0 ... 0.0 -0.03 252 -0.03 ... -0.02999 -0.03 253 -0.06 ... -0.03001 -0.03 254 !FE ... 0.03001 -0.03 Excel says: #NUM!

##### FLOOR
 A B C D 256 0.0 =FLOOR( C256, D256 ) 0.0 0.03 257 0.0 ... 0.02999 0.03 258 0.03 ... 0.03 0.03 259 0.03 ... 0.03001 0.03 260 512000.0 ... 639999.9 128000.0 261 0.0 ... 0.0 -0.03 262 0.0 ... -0.02999 -0.03 263 -0.03 ... -0.03001 -0.03 264 !FE ... 0.03001 -0.03 Excel says: #NUM!

##### ROUND
 A B C D 266 12.0 =ROUND( C266, D266 ) 12.0049 2.0 267 12.01 ... 12.005 2.0 268 13.0 ... 12.999 2.0 269 12.0 ... 12.0001 2.0 270 -12.0 ... -12.0049 2.0 271 -12.01 ... -12.005 2.0 272 -13.0 ... -12.999 2.0 273 -12.0 ... -12.0001 2.0

##### ROUND to left of decimal point
 A B C D 274 12300.0 =ROUND( C274, D274 ) 12345.0 -2.0 275 10000.0 ... 12345.0 -4.0

##### ROUNDDOWN
 A B C D 277 3.0 =ROUNDDOWN( C277, D277 ) 3.2 0.0 278 120.0 ... 123.456 -1.0 279 3.141 ... 3.14159 3.0 280 3.1415 ... 3.14159 4.0 281 -3.141 ... -3.14159 3.0 282 -3.1415 ... -3.14159 4.0

##### ROUNDUP
 A B C D 284 4.0 =ROUNDUP( C284, D284 ) 3.2 0.0 285 130.0 ... 123.456 -1.0 286 3.142 ... 3.14159 3.0 287 3.1416000000000004 ... 3.14159 4.0 288 -3.142 ... -3.14159 3.0 289 -3.1416000000000004 ... -3.14159 4.0

##### TRUNC
 A B C D 291 12.0 =TRUNC( C291 ) 12.999 292 12.0 ... 12.0 293 -12.0 ... -12.0 294 -12.0 ... -12.999 295 0.0 ... 0.0 296 0.0 ... 0.999 297 0.0 ... -0.999 298 12.0 =TRUNC( C298, D298 ) 12.009 2.0 299 12.01 ... 12.01 2.0 300 12.99 ... 12.999 2.0 301 12.0 ... 12.001 2.0 302 -12.0 ... -12.0 2.0 303 -12.0 ... -12.009 2.0 304 -12.01 ... -12.01 2.9 305 -12.0 ... -12.001 2.0 306 12300.0 ... 12345.0 -2.0 307 10000.0 ... 12345.0 -4.0

##### EVEN
 A B C 309 -4.0 =EVEN( C309 ) -3.0 310 -4.0 ... -2.001 311 -2.0 ... -2.0 312 -2.0 ... -1.001 313 -2.0 ... -1.0 314 0.0 ... 0.0 315 2.0 ... 1.0 316 2.0 ... 1.001 317 2.0 ... 2.0 318 4.0 ... 2.001 319 4.0 ... 3.0

##### ODD
 A B C 321 -3.0 =ODD( C321 ) -3.0 322 -3.0 ... -2.0 323 -3.0 ... -1.001 324 -1.0 ... -1.0 325 -1.0 ... -0.0010 326 1.0 ... 0.0 327 1.0 ... 0.0010 328 1.0 ... 1.0 329 3.0 ... 1.001 330 3.0 ... 2.0 331 3.0 ... 3.0

##### INT
 A B C 333 -3.0 =INT( C333 ) -3.0 334 -3.0 ... -2.5 335 -2.0 ... -2.0 336 -2.0 ... -1.5 337 -1.0 ... -1.0 338 0.0 ... 0.0 339 1.0 ... 1.0 340 1.0 ... 1.5 341 2.0 ... 2.0 342 2.0 ... 2.5 343 3.0 ... 3.0

##### EXP
 A B C 345 0.049787068367863944 =EXP( C345 ) -3.0 346 0.0820849986238988 ... -2.5 347 0.1353352832366127 ... -2.0 348 0.22313016014842982 ... -1.5 349 0.36787944117144233 ... -1.0 350 1.0 ... 0.0 351 2.71828182845905 ... 1.0 352 4.4816890703380645 ... 1.5 353 7.38905609893065 ... 2.0 354 12.182493960703473 ... 2.5 355 20.085536923187668 ... 3.0

##### POWER
 A B C D 357 65536.0 =POWER( C357, D357 ) 256.0 2.0 358 -1.84528125E8 ... -45.0 5.0 359 20959.155637813903 ... 1.01 1000.0 360 16.0 ... 256.0 0.5 361 40.315403854658385 ... 20.0 1.234 362 21145.169098491155 ... 1.01 1000.888 363 0.09090909090909091 ... 11.0 -1.0 364 0.4444444444444444 ... 1.5 -2.0 365 0.005083366622820051 ... 2.0 -7.62 366 1.0 ... 0.0 0.0 Excel says: #NUM! 367 !NaN/FE ... -4.0 0.5 Excel says: #NUM!

##### LN
 A B C 369 -6.907755278982137 =LN( C369 ) 0.0010 370 -2.3025850929940455 ... 0.1 371 0.0 ... 1.0 372 0.009950330853168092 ... 1.01 373 0.999896315728952 ... 2.718 374 1.0002641656503337 ... 2.719 375 20.72326583694641 ... 1.0E9 376 !-Inf/FE ... 0.0 Excel says: #NUM! 377 !NaN/FE ... -5.0 Excel says: #NUM!

##### LOG
 A B C D 379 -3.0 =LOG( C379 ) 0.0010 380 0.0 ... 1.0 381 1.0 ... 10.0 382 1.0413926851582251 ... 11.0 383 -2.0959032742893844 =LOG( C383, D383 ) 0.1 3.0 384 0.0 ... 1.0 3.0 385 2.095903274289385 ... 10.0 3.0 386 -0.9163255830492104 ... 0.1 12.34 387 0.9163255830492106 ... 10.0 12.34 388 0.6566510978626311 ... 0.1 0.03 389 -0.6566510978626313 ... 10.0 0.03 390 !-Inf/FE =LOG( C390 ) 0.0 Excel says: #NUM! 391 !NaN/FE ... -2.0 Excel says: #NUM! 392 0.0 =LOG( C392, D392 ) 10.0 0.0 Excel says: #NUM! 393 !NaN/FE ... 10.0 -2.0 Excel says: #NUM! 394 !-Inf/FE ... 0.0 10.0 Excel says: #NUM! 395 !NaN/FE ... -2.0 10.0 Excel says: #NUM! 396 !+Inf/FE ... 2.0 1.0 Excel says: #DIV/0!

##### LOG10
 A B C 398 -3.0 =LOG10( C398 ) 0.0010 399 -0.6989700043360187 ... 0.2 400 0.0 ... 1.0 401 0.004321373782642578 ... 1.01 402 1.0 ... 10.0 403 1.0004340774793186 ... 10.01 404 9.0 ... 1.0E9 405 !-Inf/FE ... 0.0 Excel says: #NUM! 406 !NaN/FE ... -2.0 Excel says: #NUM!

##### MOD
 A B C D 408 0.0 =MOD( C408, D408 ) 33.0 -3.0 409 2.0 ... 17.0 5.0 410 -3.0 ... 17.0 -5.0 411 3.0 ... -17.0 5.0 412 -2.0 ... -17.0 -5.0 413 0.5 ... 17.0 5.5 414 1.84 ... 34.0 2.01 415 !NaN/AE ... 10.0 0.0 Excel says: #DIV/0!

##### SQRT
 A B C 417 0.03162277660168379 =SQRT( C417 ) 0.0010 418 0.1 ... 0.01 419 0.99498743710662 ... 0.99 420 1.0 ... 1.0 421 1.004987562112089 ... 1.01 422 3.1622776601683795 ... 10.0 423 10.0 ... 100.0 424 316.22776601683796 ... 100000.0 425 0.0 ... 0.0 426 !NaN/FE ... -1.0 Excel says: #NUM!

##### FACT
 A B C 428 !FE =FACT( C428 ) -1.0 Excel says: #NUM! 429 1.0 ... 0.0 430 1.0 ... 1.0 431 2.0 ... 2.0 432 6.0 ... 3.0 433 24.0 ... 4.0 434 120.0 ... 5.0 435 720.0 ... 6.0 436 5040.0 ... 7.0 437 40320.0 ... 8.0 438 362880.0 ... 9.0 439 3628800.0 ... 10.0 440 3.99168E7 ... 11.0 441 4.790016E8 ... 12.0 442 6.2270208E9 ... 13.0 443 8.71782912E10 ... 14.0 444 1.307674368E12 ... 15.0 445 2.43290200817664E18 ... 20.0 446 1.0 ... 1.1 447 1.0 ... 1.9 448 2.0 ... 2.1

##### COMBIN
 A B C D 450 1.0 =COMBIN( C450, D450 ) 0.0 0.0 451 1.0 ... 1.0 0.0 452 1.0 ... 1.0 1.0 453 1.0 ... 2.0 0.0 454 2.0 ... 2.0 1.0 455 1.0 ... 2.0 2.0 456 1.0 ... 3.0 0.0 457 3.0 ... 3.0 1.0 458 3.0 ... 3.0 2.0 459 1.0 ... 3.0 3.0 460 10.0 ... 10.0 1.0 461 252.0 ... 10.0 5.0 462 120.0 ... 10.0 7.0 463 !FE ... 0.0 1.0 Excel says: #NUM! 464 !FE ... 1.0 -1.0 Excel says: #NUM! 465 !FE ... -1.0 1.0 Excel says: #NUM!