CALC 1 Home Documentation Home Contact
Loading

CALC 1 Constants

 

Constant Description Example Result
calc Method constant for days360 to select the Excel/Calc method. calc 0
db30360 Financial methods constant for 30 days per month, 360 days per year, Calc method. db30360 0
db30e360 Financial methods constant for 30 days per month, 360 days per year, european method. db30e360 4
dbact360 Financial methods constant for actual days per month, 360 days per year. dbact360 2
dbact365 Financial methods constant for actual days per month, 365 days per year. dbact365 3
dbactact Financial methods constant for actual days per month, actual days per year. dbactact 1
dblmax Maximum representable finite floating-point number. dblmax 1.797e+308
dblmin Minimum representable finite floating-point number. dblmin 2.225e-308
dr Degrees to radians (pi/180). dr 0.0174532
euro Method constant for days360 to select the European method. euro 1
false Used to indicate boolean false in a logical function. false 0
flagbe Flag memory location of the financial beginning or end mode. flagbe 10
flagdrm Flag memory location of the trigonometric degree or radian mode. flagdrm 11
listf f (financial) list index. listf 2
listx x list index. listx 0
listy y list index. listy 1
m1pi 1/pi. m1pi 0.32
m2pi 2/pi. m2pi 0.64
m2sqrtpi 2/sqrt(pi). m2sqrtpi 1.13
maxformulamem Last formula memory index. maxformulamem 99
maxusermem Last user memory index. maxusermem 99
me e (mathematical constant) me 2.72
mln10 log e 10. mln10 2.3
mln2 log e 2. mln2 0.69
mlog10e log 10 e. mlog10e 0.43
mlog2e log 2 e. mlog2e 1.44
mpi π (mathematical constant) mpi 3.14
mpi2 pi/2. mpi2 1.57
mpi4 pi/4. mpi4 0.79
msqrt12 1/sqrt(2). msqrt12 0.71
msqrt2 sqrt(2). msqrt2 1.41
nasd Method constant for days360 to select the NASD method. nasd -1
nfstyledec Used in STONFSTYLE() to set the number formatter style to decimal. nfStyleDec 1
nfstylenone Used in STONFSTYLE() to set the number formatter style to none. nfstylenone 0
nfstylesci Used in STONFSTYLE() to set the number formatter style to scientific. nfStyleSci 4
true Used to indicate boolean true in a logical function. true 1