#### On-line Stats

• Created Formulas: 667
• Created Widgets: 3982
APIs, Widgets & Apps
"Making the complex simple"

# Functions Help

All functions for the formulas used in the Calculator Widgets are based upon standard functions in excel. Most syntaxes are equal to excel, but when adding formulas in the "simple formula" or "formula express" use ';' instead of ',' exactly like a spreadsheet for arguments in functions.

Feel free to contact us on E-Mail: info@formloop.com, if you want a custom function or other features.

## abs

Description: Returns the absolute value of a value in the parentheses.
Syntax: abs(value)
Example: abs(4)

## acos

Description: Returns a float number for arc cosine of an angle in the parentheses.
Syntax: acos(angle)
Example: acos(pi/4)

## asin

Description: Returns a float number for arc sine of an angle in the parentheses.
Syntax: asin(angle)
Example: asin(pi/4)

## atan

Description: Returns a float number for arc tangent of an angle in the parentheses.
Syntax: atan(angle)
Example: atan(pi/4)

## atanh

Description: Returns a float number for inverse hyperbolic tangent of an angle in the parentheses.
Syntax: atanh(angle)
Example: atanh(pi/4)

## ceil

Description: This function always round up the value in the parentheses to the next integer value.
Syntax: ceil(value)
Example: ceil(43.23)

## cos

Description: Returns a float number for cosine of an angle in the parentheses.
Syntax: cos(angle)
Example: cos(2*pi)

## exp

Description: Returns e raised to the power of the value in the parentheses.
Syntax: exp(value)
Example: exp(4)

## fact

Description: Returns the factorial of numbers below 171 and fact(170) is the max factorial value
Syntax: fact(value)
Example: fact(3)

## flcur

Description: Returns the daily currency rate for two currencies and a value to convert, returns 1 if no argument is supplied and if no currency is found for that currency code it returns the input. List of avaliable currencies and currency codes can be found here.Three arguments have to be passed for the function to work. The function is usually used together with an if statement.
Syntax: flcur(integer, integer, float)
Example: flcur(200,300,17.4)

## flif

Description: IF statement that accepts three arguments separated by comma, first argument is the condition to test against then value if true and then value if false. The if statement can also be followed by a logical expression like 'and' or 'or'.
Syntax: flif(condition,value if true,value if false)
Example: flif(x==3,10,15)

## floor

Description: This function always round down the value in the parentheses to the integer value.
Syntax: floor(value)
Example: floor(43.23)

## irr

Description: Returns Internal Rate of Return IRR, type can be 1 for annual, 2 for semiannual, 4 for quarter or 12 for month. The function accepts any number of cashflows. If no type is supplied it will use Annual. Investment should be a positive value, there is no need in adding a minus sign.
Syntax: irr(type, investment, cashflow 1, ....cashflow n)
Example: irr(1,1000,600,200,600)

## log

Description: Returns the natural logarithm for the value in the parentheses.
Syntax: log(value)
Example: log(1)

## log10

Description: Returns the base 10 logarithm for the value in the parentheses.
Syntax: log10(value)
Example: log10(10)

## max

Description: Picks the maximum value out of a serie of values in parentheses separated by a comma. This function accepts multiple values as arguments
Syntax: max(value 1,value 2,value n)
Example: max(4,5,8,10)

## min

Description: Picks the minimum value out of a serie of values in parentheses separated by a comma. This function accepts multiple values as arguments.
Syntax: min(value 1,value 2,value n)
Example: min(4,5,8,10)

## npv

Description: Returns Net Present Value NPV, type can be 1 for annual, 2 for semiannual, 4 for quarter or 12 for month. Rate set as a floatnumber. The function accepts any number of cashflows. If no type is supplied it will use Annual. Investment should be a positive value, there is no need in adding a minus sign.
Syntax: npv(type, investment, rate, cashflow 1, ....cashflow n)
Example: npv(1, 100000, 10, 10000, 20000,30000)

## round

Description: Rounds the first value in parentheses with precision of second value. Second value must be an integer and can be plus for places after decimal and minus for places before decimal.
Syntax: round(value,precision)
Example: round(4345,-2)

## sin

Description: Returns a float number for sine of an angle in the parentheses.
Syntax: sin(angle)
Example: sin(2*pi)

## sqrt

Description: Returns the square root for the value in the parentheses.
Syntax: sqrt(value)
Example: sqrt(4)

## tan

Description: Returns a float number for tangent of an angle in the parentheses.
Syntax: tan(angle)
Example: tan(pi/4)