Mathematics

INT(NumericValue)

Convert to Int type

・The decimal part is rounded toward zero.
・The result is an Int type.

Argument

NumericValue

The underlying numeric value

Return Value

Number converted to Int

Related

FLOOR: Round down, ROUND: Round off, CEIL: Round up

FLOAT(NumericValue)

Convert to Real type

・The result is a Real type.

Argument

NumericValue

The underlying numeric value

Return Value

Number converted to Real type

Related

INT:Integerization (Round toward zero)

FLOOR(NumericValue)

Round down decimal places

・Get the largest Int that does not exceed that number (floor function).
・FLOOR(12.5) is 12, FLOOR(-12.5) is -13.
・The result is all zeros after the decimal point, but it is a Real type.

Argument

NumericValue

The underlying numeric value

Return Value

The value with the fractional part rounded down

Related

INT:Integerization (Round toward zero), ROUND: Round off, CEIL: Round up

Example

A=FLOOR(12.345)

ROUND(NumericValue)

Round off the fractional part to the nearest Int

・The result is all zeros after the decimal point, but it is a Real type.
・ROUND(12.5) is 13, ROUND(-12.5) is -13.

Argument

NumericValue

The underlying numeric value

Return Value

The value with the fractional part rounded off

Related

INT:Integerization (Round toward zero), FLOOR: Round down, CEIL: Round up

Example

A=ROUND(12.345)

CEIL(NumericValue)

Round up after the decimal point

・Get the smallest Int that does not fall below that number (ceiling function).
・CEIL(12.5) is 13, CEIL(-12.5) is -12.
・The result is all zeros after the decimal point, but it is a Real type.

Argument

NumericValue

The underlying numeric value

Return Value

The value with the fractional part rounded off

Related

INT:Integerization (Round toward zero), ROUND: Round off, FLOOR: Round down

Example

A=CEIL(12.345)

ABS(NumericValue)

Get the absolute value

Argument

NumericValue

Numeric value for obtaining absolute value

Return Value

Absolute value

Example

A=ABS(-12.345)

SGN(NumericValue)

Get the sign

Argument

NumericValue

Numeric value to get sign

Return Value

Returns either 1, 0 or -1 depending on the sign of the argument

1 Positive Value
0 0
-1 Negative Value

Example

A=SGN(12.345)

MIN(NumericArray)

Get smallest value in a specified numeric array

Argument

NumericArray

Numeric array for checking minimum value

Return Value

Smallest number in numeric array

Example

DIM TMP[2]=[50,3]
A=MIN(TMP)

MIN(NumericValue,NumericValue[,NumericValue...])

Get the smallest value from multiple specified numbers

Argument

NumericValue

Arrange the numerical value whose minimum value is to be examined as argument

Return Value

Smallest number of arguments passed

Example

A=MIN(1,2,3,4)

MAX(NumericArray)

Get the largest value in a specified numeric array

Argument

NumericArray

Numeric array to get the maximum value

Return Value

Largest number in the numeric array

Example

DIM TMP[2]=[50,3]
A=MAX(TMP)

MAX(NumericValue,NumericValue[,NumericValue...])

Get the largest value from multiple specified numbers

Argument

NumericValue

Arrange the numerical value whose maximum value is to be examined as argument

Return Value

The largest number of arguments passed

Example

A=MAX(1,2,3,4)

RND([SeedID,]MaximumValue)

Get Int random number

Argument

SeedID

Random number series: 0 to 7

MaximumValue

Maximum number of random numbers to get

Return Value

A random Int between 0 and the maximum value -1.

Example

A=RND(100)

RNDF([SeedID])

Get a Real random number

Argument

SeedID

Random number series: 0 to 7

Return Value

A random Real number between 0 and 1

Example

A=RNDF()

RANDOMIZE SeedID [,SeedValue]

Initialize the random number sequence

Argument

SeedID

Type of random number series: 0 to 7

SeedValue

An Int value that selects a random number sequence

・The order of the values returned by RND and RNDF is determined by the seed value.
・If 0 is specified, the available entropy information is used as the seed value.
・If not specified, it's 0.

Example

RANDOMIZE 0

SQR(NumericValue)

Calculate the square root

Argument

NumericValue

Numeric value for obtaining the square root

Return Value

The calculated square root

Example

A=SQR(4)

EXP([NumericValue])

Calculates the power of e(BaseOfNaturalLogarithms)

Argument

NumericValue

Index number

・If not specified, the constant #EXP is returned.

Return Value

The calculated result

Example

A=EXP(2)

POW(NumericValue,Multiplier)

Calculate the power

Argument

NumericValue

Numeric value for calculating power

Multiplier

Power multiplier

Return Value

The calculated result

Example

A=POW(1,4)

LOG(NumericValue[,Base])

Calculate the logarithm

Argument

NumericValue

True number: Positive Real

Base

Base: Positive Real

・If not specified, the natural logarithm is calculated.

Return Value

The calculated result

Example

A=LOG(2,2)

RAD(NumericValue)

Convert angular units from degrees to radians

・It can be used in constant expressions.

Argument

NumericValue

Angle in degrees

Return Value

Angle in radians

Example

R=RAD(45)

DEG(NumericValue)

Convert angular units from radians to degrees

・It can be used in constant expressions.

Argument

NumericValue

Angle in radians

Return Value

Angle in degrees

Example

A=DEG(0.5*#PI)

SIN(Angle)

Calculate the sine

Argument

Angle

Angle in radians

Return Value

The calculated sine value

Example

A=SIN(RAD(45))

COS(Angle)

Calculate the cosine

Argument

Angle

Angle in radians

Return Value

The calculated cosine value

Example

A=COS(RAD(45))

TAN(Angle)

Calculate the tangent

Argument

Angle

Angle in radians

Return Value

The calculated tangent value

Example

A=TAN(RAD(45))

ASIN(NumericValue)

Calculate the arc sine (inverse function of SIN)

Argument

NumericValue

-1.0 to 1.0

Return Value

The calculated angle (in radians)

Example

A=ASIN(0)

ACOS(NumericValue)

Calculate the arc cosine (inverse function of COS)

Argument

NumericValue

-1.0 to 1.0

Return Value

The calculated angle (in radians)

Example

A=ACOS(1)

ATAN(NumericValue)

Calculate the arc tangent (inverse function of TAN) (from numeric value)

Argument

NumericValue

Numeric value to calculate the angle

Return Value

The calculated angle (in radians)

Example

A=ATAN(1)

ATAN(CoordinateY,CoordinateX)

Calculate the arc tangent (inverse function of TAN) (from XY coordinates)

Argument

CoordinateY,X

Coordinate value to calculate the angle

・The direction from the origin is calculated as an angle.
・Pay attention to the order of arguments.

Return Value

The calculated angle (in radians)

Example

A=ATAN(1,1)

SINH(NumericValue)

Calculate the hyperbolic sine

Argument

NumericValue

Numeric value to calculate the hyperbolic sine

Return Value

The calculated hyperbolic sine

Example

A=SINH(1)

COSH(NumericValue)

Calculate the hyperbolic cosine

Argument

NumericValue

Numeric value to calculate the hyperbolic cosine

Return Value

The calculated hyperbolic cosine

Example

A=COSH(1)

TANH(NumericValue)

Calculate the hyperbolic tangent

Argument

NumericValue

Numeric value to calculate the hyperbolic tangent

Return value

The calculated hyperbolic tangent

Example

A=TANH(0.5)

CLASSIFY(NumericValue)

Judge normal numbers, infinity, and non-numeric values (NaN)

Argument

NumericValue

Number to check

Return Value

0 Normal Value
1 Infinity
2 NaN

Example

A=CLASSIFY(0.5)