- Data Service
- About
- Data Sources
- Azure Data Market
- CSV
- Date Time
- DB2
- Directory
- Ebay
- European Central Bank
- Excel
- Google Analytics
- Google Big Query
- Google Trends
- HTML Tables
- Import.io
- JSON
- Microsoft Office Access
- MongoDB
- MySQL
- OData
- Oracle
- PostgreSQL
- Python
- Quandl
- R Language
- Salesforce.com
- Search Metrics
- SharePoint
- SQL Server
- SQL Server Stored Procedure
- Statistics Denmark
- TARGIT Analysis
- Weather
- Windows Event Log
- Wine.com
- Cubes
- Formats
- Installation

# Math & Trig

## abs

(float Number)

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Example: ABS(-2) returns absolute value of -2 (2).

Example: ABS(-2*-8) returns absolute value (16).

Number: Required. The real number of which you want the absolute value.

## acos

(float Number)

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number.

The returned angle is given in radians in the range 0 (zero) to pi.

Example: ACOS(-0.5) is an arccosine of -0.5 in radians, 2*pi/3 (2.094395).

Number: Required. The cosine of the angle you want and must be from -1 to 1.

## asin

(float Number)

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number.

The returned angle is given in radians in the range -pi/2 to pi/2.

Example: ASIN(-0.5) is an arcsine of -0.5 in radians, -pi/6 (-0.5236).

Number: Required. The sine of the angle you want and must be from -1 to 1.

## atan

(float Number)

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number.

The returned angle is given in radians in the range -pi/2 to pi/2.

Example: ATAN(1) is an arctangent of 1 in radians, pi/4 (0.785398).

Number: Description

## atan2

(float x_num, float y_num)

Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.

The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num).

The angle is given in radians between -pi and pi, excluding -pi.

Example: ATAN2(1, 1) is an arctangent of the point 1,1 in radians, pi/4 (0.785398)

x_num: Required. The x-coordinate of the point.

## ceiling

(float Number)

Returns the smallest integral value that is greater than or equal to the specified double-precision floating-point number.

Example: CEILING(5.6) return 6.

Number: Required. A double-precision floating-point number you want to round.

## cos

(float Number)

Returns the cosine of the given angle.

Example: COS(1.047) is a cosine of 1.047 radians (0.500171).

Number: Required. The angle in radians for which you want the cosine.

## cosh

float Number)

Returns the hyperbolic cosine of a number.

Example: COSH(4) is a hyperbolic cosine of 4 (27.30823)

Number: Required. Any real number for which you want to find the hyperbolic cosine.

## epsilon

()

Represents the natural logarithmic base.

Example: EPSILON() returns 4.94066

## exp

(float Number)

Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Example: EXP(2) is a base of the natural logarithm e raised to the power of 2 (7.389056)

Number: Required. The exponent applied to the base e.

## floor

(float Number)

Returns the largest integer less than or equal to the specified double-precision floating-point number.

Example: FLOOR(1.5) rounds 1.5 down to the nearest integer (1)

Example: FLLOR(-1.5) rounds -1.5 down to nearest integer(-2)

Number: Required. A double-precision floating-point number you want to round.

## int

(float Number)

Rounds a number down to the nearest integer.

Example: INT(1.5) rounds 1.5 down to the nearest integer (1)

Number: Required. The real number you want to round down to an integer.

## ln

(float Number)

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Example: LN(86) is a natural logarithm of 86 (4.454347)

Number: Required. The positive real number for which you want the natural logarithm.

## log

(float Number)

Returns the logarithm of a number to the base you specify. Base is assumed to be 10.

Example: LOG(1000) is a logarithm of 1000 (3).

Number: Required. The positive real number for which you want the logarithm.

## log10

(float Number)

Returns the base-10 logarithm of a number.

Example: LOG10(10) is a base-10 logarithm of 10 (1)

Number: Required. The positive real number for which you want the base-10 logarithm.

## numeric

(Object Value, string replacement)

Removes all non-decimal characters from the string.

Example: NUMERIC("$1.000") removes the non-decimal characters (1000).

Value: Required. Text in which you want to replace characters.

## pi

()

Returns the number 3.14159265358979, the mathematical constant pi.

Example: PI() returns 3.14159265358979.

## power

(float Number, float power)

Returns the result of a number raised to a power.

Example: POWER(5,2) is a 5 squared (25)

Number: Required. A double-precision floating-point number to be raised to a power.

## rand

()

Returns an evenly distributed random real number greater than or equal to 0 and less than 1.

A new random real number is returned every time the formula is calculated.

Example: RAND() returns a random number between 0 and 1 (varies)

## randbetween

(float Bottom, float Top)

Returns a random integer number between the numbers you specify.

A new random integer number is returned every time the formula is calculated.

Example: RANDBETWEEN(1,100) is a new random number between 1 and 100 (varies)

Bottom: Required. The smallest integer RANDBETWEEN will return.

## round

(float Value,decimals)

Rounds a decimal value to the nearest integral value.

Example: ROUND(12.123,2) returns a number (12.12)

Value: A decimal number to be rounded.

## sign

(float Number)

Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.

Example: SIGN(-0.00001) is a Sign of a negative number (-1).

Number: Required. Any real number.

## sin

(float Number)

Returns the sine of the given angle.

Example: SIN(PI()) is a sine of pi radians (1.2246).

Number: Required. The angle in radians for which you want the sine.

## sinh

(float Number)

Returns the hyperbolic sine of a number.

Example: SINH(1) is a hyperbolic sine of 1 (1.175201194)

Number: Required. Any real number.

## sqrt

(float Number)

Returns a positive square root.

Example: SQRT(16) is a square root of 16 (4).

Number: Required. The number for which you want the square root.

## sum

(Object Number)

The SUM function adds all the numbers that you specify as arguments.

Example: SUM(3, 2) adds 3 and 2 (5).

Number: Required. The first number argument that you want to add.

## tan

(float Number)

Returns the tangent of the given angle.

Example: TAN(0.785) is a tangent of 0.785 radians (0.99920).

Number: Required. The angle in radians for which you want the tangent.

## tanh

(float Number)

Returns the hyperbolic tangent of a number.

Example: TANH(-2) is a hyperbolic tangent of -2 (-0.96403)

Number: Required. Any real number.

## trunc

(float Number)

Truncates a number to an integer by removing the fractional part of the number.

Example: TRUNC(8.9) is an integer part of 8.9 (8)

Number: Required. The number you want to truncate.