Osymo Calc Reference

Osymo Calc Reference

You can enter formulas using keyboard like SMS or you can use Field/Insert menu for entering special chars and functions. After entering the formula press the action key to evaluate the result. The formulas are Excel compatible.

Formulas can contain:

Values

What Comment Example(s)
Numbers The decimal separator (. or ,) is taken from the Regional settings of your device. 123.45
-1.2e55
Text Enclosed in " character. "Hello World"
Date/Time The format of the date/time value is taken from the Regional settings of your device.
You must specify a year in the date.
8/22/99 (in the U.S.A)
22.8.99 (in Germany)
10:44
12/30/1999 14:25:30
Boolean true or false true
false

 

Operators

Arithmetic operators: +, -, /, *, %, ^ (exponentiation operator).
Comparative operators: =, <>, <, <=, >, >=.
Text joining operator: & (Example: "Hello " & "world!")

 

Functions

Math & Trig Functions

Abs(number) Returns the absolute value of a number Abs(-3) = 3
Acos(number) Returns the arccosine of a number. The number must be from -1 to 1 Acos(0) = 1.57079
Acosh(number) Returns the inverse hyperbolic cosine of a number. The number must be greater or equal to 1 Acosh(1) = 0.04613
Asin(number) Returns the arcsine of a number. The number must be from -1 to 1 Asin(-0.5) = -0.5236
Asinh(number) Returns the inverse hyperbolic sine of a number Asinh(8) = 2.77647
Atan(number) Returns the arctangent of a number Atan(0.5) = 0.46365
Atan2(x,y) Returns the arctangent of the specified x and y coordinates Atan2(1, 1) = 0.785398
Atanh(number) Returns the inverse hyperbolic tangent of a number. The number must be between -1 and 1 (excluding -1 and 1) Atanh(-0.1) = -0.10034
Ceiling(number, significance) Returns the number rounded up to the nearest multiple of the significance Ceiling(10.43, 0.1) = 10.5
Combin(number, numberChosen) Returns the number of combinations. Number is the number of items, numberChosen is the number of items in each combination Combin(10, 2) = 45
Cos(number) Returns the cosine of the given angle Cos(0.5) = 0.87758
Cosh(number) Returns the hyperbolic cosine of a number Cosh(5) = 74.20995
Degrees(number) Converts radians into degrees Degrees(Pi()/2) = 90
Even(number) Returns the number rounded up to the nearest even integer Even(1.3) = 2
Exp(number) Returns e raised to the power of the number Exp(Ln(2)) = 2
Fact(number) Returns the factorial of a number. The number must be nonnegative number Fact(5) = 120
Floor(number, significance) Rounds the number down, toward zero, to the nearest multiple of the significance Floor(3.5, 1) = 3
Int(number) Rounds a number down to the nearest integer Int(1.7) = 1
Ln(number) Returns the natural logarithm of a number Ln(Exp(2)) = 2
Log(number, base) Returns the logarithm of a number to the base you specify . If the base is omitted, it is assumed to be 10 Log(100, 10) = 2
Log10(number) Returns the logarithm (base 10) of a number Log10(100) = 2
Mod(number, divisor) Returns the remainder after the number is divided by the divisor Mod(5, 2) = 1
Odd(number) Returns the number rounded up to the nearest odd integer Odd(2) = 3
Pi() Returns the number 3.14159265358979, the mathematical constant π  
Power(number, power) It raises the number to the power. You can also use the "^" operator (e.g. 4^2) Power(4,2) = 16
Product(number, number, ...) Multiplies all the numbers given as arguments and returns the product Product(2, 3, 5) = 30
Radians(number) Converts degrees to radians Radians(180) = 3.14159
Rand() Returns a random number greater than or equal to 0 and less than 1  
Round(number) Rounds a number to the specified number of digits Round(5.46, 1) = 5.5
RoundDown(number, numDigits) Rounds the number down, toward zero, to the specified number of digits RoundDown(40.8, 0) = 40
RoundUp(number, numDigits) Rounds the number up, away from zero, to the specified number of digits RoundUp(39.1, 0) = 40
Sign(number) Returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative Sign(-5) = -1
Sin(number) Returns the sine of the given angle Sin(Pi()/2) = 1
Sinh(number) Returns the hyperbolic sine of the number Sinh(3) = 10.01787
Sqrt(number) Returns the square root Sqrt(4) = 2
Sum(number, number, ...) Return the sum of all the numbers in the list of arguments Sum(10, 20) = 30
Sumsq(number, number, ...) Returns the sum of squares of the arguments Sumsq(2, 5) = 29
Tan(number) Returns the tangent of the given angle Tan(5) = -3.38051
Tanh(number) Returns the hyperbolic tangent of the number Tanh(1) = 0.76159
Trunc(number, numDigits) Truncates the number to an integer. The argument numDigits is the precision of the truncation. The default value for the numDigits is 0 Trunc(-7.8) = -7

 

Statistical Functions

Avedev(number, number, ...) Returns the average of the absolute deviations of data points from their mean
Average(number, number, ...) Returns the average of the arguments
AverageA(number, number, ...) Returns the average of all values in a set of values (TRUE is 1, FALSE and texts are 0)
Betadist(x, alfa, beta, A, B) Returns the cumulative beta probability density function
Beatainv(probability, alfa, beta, A, B) Returns the inverse of the cumulative beta probability density function
Binomdist(numOfSuccess, trials, probability, cumulative) Returns the individual term binomial distribution probability
Confidence(alfa, standardDeviation, size) Returns the confidence interval for a population mean
Correl(reference1, reference2) Returns the correlation coefficient between two data sets
Critbinom(trials, probability, alfa) Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value
Devsq(number, number, ...) Returns the sum of squares of deviations of data points from their sample mean
Expondist(x, lambda, cumulative) Returns the exponential distribution value
Fdist(x, degOfFreedom1, degOfFreedom2) Returns the F probability distribution for two data sets
Finv(probability, degOfFreedom1, degOfFreedom2) Returns the inverse of the F probability distribution
Fisher(number) Returns the Fisher transformation value
Fisherinv(number) Returns the inverse of the Fisher transformation
Forecast(x, seriesY, seriesX) Predicts a future value along a linear trend
Ftest(reference1, reference2) Returns the result of a F-test
Gammadist(x, alfa, beta, cumulative) Returns the gamma distribution value
Gammainv(probability, alfa, beta) Returns the inverse of the gamma cumulative distribution
Gammaln(number) Returns the natural logarithm of the gamma function
Geomean(number, number, ...) Returns the geometric mean of a range of positie numeric data
Harmean(number, number, ...) Returns the harmonic mean of a data set of positive numbers
Hypgeomdist(numSuccInSample, size, numSuccInPop, popSize) Returns the hypergeometric distribution
Chidist(x, degOfFreedom) Returns the one-tailed probability of the chi-squared distribution
Chiinv(x, degOfFreedom) Returns the inverse of the one-tailed probability of the chi-squared distribution
Chitest(reference1, reference2) Returns the test for independence (the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom)
Kurt(number, number, ...) Returns the kurtosis of a data set
Loginv(probability, mean, standardDeviation) Returns the inverse of the lognormal cumulative distribution function of x
Lognormdist(x, mean, standardDeviation) Returns the cumulative lognormal distribution of x
Max(number, number, ...) Returns the maximum value in the list of arguments
MaxA(number, number, ...) Returns the largest value in a set of values (TRUE is 1, FALSE and texts are 0)
Median(number, number, ...) Returns the median, or the number in the middle of the set of given numbers
Min(number, number, ...) Returns the minimum value in the list of arguments
MinA(number, number, ...) Returns the smallest value in a set of values (TRUE is 1, FALSE and texts are 0)
Mode(number, number, ...) Returns the most frequently occurring, or repetitive, value in a range of data
Negbinomdist(numOfSuccess, numOfFailure, probability) Returns the negative binomial distribution
Normdist(x, mean, standardDeviation, cumulative) Returns the normal cumulative distribution for the specified mean and standard deviation
Norminv(probability, mean, standardDeviation) Returns the inverse of the normal cumulative distribution function (Nomdist)
Normsdist(z) Returns the standard normal cumulative distribution (has a mean of zero and standard deviation of one)
Normsinv(probability) Returns the inverse of the standard normal cumulative distribution function (Normsdist)
Pearson(reference1, reference2) Returns the Pearson product moment correlation coefficient r
Percentile(reference, n) Returns the n-th percentile
Percentrank(reference, x, decimal) Returns the rank of a value in a data set as a percentage of the data set
Permut(number, numberChosen) Returns the number of permutations. Number is the number of objects, numberChosen is the number of objects in each permutation
Poisson(x, mean, cumulative) Returns the Poisson distribution
Prob(values, probabilities, lowLimit, upLimit) Returns the probability that values in a range are between two limits [lowerLimit..upperLimit]
Skew(number, number, ...) Returns the skewness of a distribution
Standardize(x, mean, standardDeviation) Returns a normalized value from a distribution characterized by mean and standard deviation
Stdev(number, number, ...) Estimates the standard deviation based on a sample
StdevA(number, number, ...) Estimates standard deviation based on a sample (TRUE is 1, FALSE and texts are 0)
StdevP(number, number, ...) Calculates the standard deviation of the entire population
StdevpA(number, number, ...) Calculates standard deviation based on an entire population (TRUE is 1, FALSE and texts are 0)
Tdist(x, degOfFreedom, type) Returns the Student’s t-distribution
Tinv(probability, degOfFreedom) Returns the inverse of the Student’s t-distribution
Var(number, number, ...) Estimates the variance based on a sample
VarA(number, number, ...) Estimates variance based on a sample (TRUE is 1, FALSE and texts are 0)
VarP(number, number, ...) Calculates variance of the entire population
VarpA(number, number, ...) Calculates variance based on an entire population (TRUE is 1, FALSE and texts are 0)
Weibull(x, alfa, beta, cumulative) Returns the Weibull distribution

 

Financial Functions

Ddb(cost, salvage, life, period, factor) Returns the depreciation of an asset for a specified period using the double-declining balance method (you can specify other method). Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods over which the asset is being depreciated. Period is the period for which you want to calculate the depreciation. Period must use the same units as life. Factor is the rate at which the balance declines. If factor is omitted, it is assumed to be 2. All the arguments must be positive numbers Ddb(30000, 500, 3650, 10) = 16.357
Fv(rate, nper, pmt, pv, type) Returns the future value of an investment. Rate is the interest rate per period. Nper is the total number of payment periods in an annuity. Pmt is the payment made each period. Pv is the present value. Type can be 0 or 1 (0 - payments at the end of the period, 1 - at the beginning). If type is omitted, it is assumed to be 0 Fv(0.01, 12, -500) = 6341.25
IPmt(rate, per, nper, pv, fv, type) Returns the interest payment for an investment. Per is the period for which you want to find the interest (must be 1 <= per <= nper). For more information see Pmt Ipmt(0.01, 1, 24, 5000) = -50
Nper(rate, pmt, pv, fv, type) Returns the number of periods for an investment. For more information see Pmt Example: Nper(0.01, -100, -1000, 20000) = 101
Npv(rate, value1, value2...) Returns the net present value of an investment. Rate is the rate of discount over the length of one period. Value1, value2, are arguments representing the payments (negative values) and income (positive values) Example: Npv(10%, -10000, 4000, 5000, 6000) = 2069.53
Pmt(rate, nper, pv, fv, type) Returns the periodical payment for an annuity. Rate is the interest rate per period, nper is the number of payment periods in an annuity, pv is the present value, fv is the future value, type see Fv Pmt(0.01, 10, 10000) = -1055.82
PPmt(rate, per, nper, pv, fv, type) Returns the payment on the principa for a given period of an investment. For more information see Pmt Ppmt(0.01, 1, 36, 1000) = -23.21
Pv(rate, nper, pmt, fv, type) Returns the present value of an investment. For more information see Pmt Pv(0.01, 5*12, 1000, 0) = -44955.04
Rate(nper, pmt, pv, fv, type, guess) Returns the interest rate per period of an annuity. For more information see Pmt. Guess is your guess for what the rate will be Rate(36, -300, 10000, 0) = 0.42%
Sln(cost, salvage, life) Returns the straight-line depreciation of an asset for one period. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods Sln(40000, 5000, 8) = 4375
Syd(cost, salvage, life, period) Returns the sum-of-years' digits depreciation of an asset for a specified period. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods. Period is the period Syd(40000, 5000, 8, 8) = 972.22

 

Date & Time Functions

Date(year, month, day) Returns a particular date Year(Date(1999, 1, 1)) = 1999
DateValue(dateText) Converts a date in the form of text to a serial number DateValue("1/1/99") = 36161
Day(date) Returns the day of a date Day(1/1/99) = 1
Hour(time) Returns the hour of a time Hour(2:45) = 2
Minute(time) Returns the minutes of a time Minute(2:45) = 45
Month(date) Returns the month of a date Month(1/1/99) = 1
Now() Returns the current date and time  
Second(time) Returns the seconds of a time Second(Time(1, 45, 20)) = 20
Time(hour, min, sec) Returns a particalar time Time(1,45,0) = 1:45
TimeValue(timeText) Converts a time in the form of text to a serial number TimeValue("1:45") = 0.072917
Today() Returns the current date  
Weekday(date, type) Returns the day of the week corresponding to a date. If type = 1 or omitted returns: 1 (Sunday) through 7 (Saturday) Weekday(Date(1999,8,15)) = 1
Year(date) Returns the year of a date Year(Date(1999, 1, 1)) = 1999

 

Logical Functions

And(logical1, logical2, ...) Returns TRUE if all its arguments are TRUE, otherwise returns FALSE And(FALSE, TRUE) = FALSE
If(condition, trueValue, falseValue) Returns trueValue if condition evaluates to TRUE or falseValue if condition evaluates to FALSE If(sin(12)>1, "strange", "normal")
Not(logical) Reverses logical value Not(TRUE) = FALSE
Or(logical1, logical2, ...) Returns TRUE if any argument is TRUE, otherwise return FALSE. Example Or(FALSE, TRUE) = TRUE

Copyright Osymo. All rights reserved. Support: email@osymo.com