Passa al contenuto principale

Numbers

Calculate with numbers, convert text to numbers and format numbers for display.

Add​

Adds two numbers.

Inputs

NameTypeRequiredDetails
ADecimal numberYesFirst addend.
BDecimal numberYesSecond addend.

Outputs

NameTypeDetails
ResultDecimal numberThe sum a + b.

Subtract​

Subtracts the second number from the first.

Inputs

NameTypeRequiredDetails
ADecimal numberYesMinuend.
BDecimal numberYesSubtrahend.

Outputs

NameTypeDetails
ResultDecimal numberThe difference a - b.

Multiply​

Multiplies two numbers.

Inputs

NameTypeRequiredDetails
ADecimal numberYesFirst factor.
BDecimal numberYesSecond factor.

Outputs

NameTypeDetails
ResultDecimal numberThe product a * b.

Divide​

Divides the first number by the second.

Inputs

NameTypeRequiredDetails
ADecimal numberYesDividend.
BDecimal numberYesDivisor.

Outputs

NameTypeDetails
ResultDecimal numberThe quotient a / b.

Remainder after division​

Returns the remainder of dividing a by b.

Inputs

NameTypeRequiredDetails
ADecimal numberYesDividend.
BDecimal numberYesDivisor.

Outputs

NameTypeDetails
ResultDecimal numberThe remainder a % b.

Round​

Rounds a number to the nearest whole number.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number to round.

Outputs

NameTypeDetails
ResultWhole numberThe rounded whole number.

Round to decimals​

Rounds a value to the given number of decimal places.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe value to round.
DecimalsWhole numberYesNumber of decimal places to keep. Minimum: 0.

Outputs

NameTypeDetails
ResultDecimal numberThe rounded value.

Floor​

Rounds a number down to the nearest whole number.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number to floor.

Outputs

NameTypeDetails
ResultWhole numberThe rounded-down whole number.

Ceiling​

Rounds a number up to the nearest whole number.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number to round up.

Outputs

NameTypeDetails
ResultWhole numberThe rounded-up whole number.

Minimum​

Returns the smallest value in a list.

Inputs

NameTypeRequiredDetails
ValuesList of Decimal numberYesNumbers to compare. Minimum items: 1.

Outputs

NameTypeDetails
ResultDecimal numberThe smallest value.

Maximum​

Returns the largest value in a list.

Inputs

NameTypeRequiredDetails
ValuesList of Decimal numberYesNumbers to compare. Minimum items: 1.

Outputs

NameTypeDetails
ResultDecimal numberThe largest value.

Limit between min and max​

Constrains a value to the range [min, max].

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe value to clamp.
MinimumDecimal numberYesThe lower bound.
MaximumDecimal numberYesThe upper bound.

Outputs

NameTypeDetails
ResultDecimal numberThe clamped value.

Sum​

Adds together all values in a list. An empty list sums to 0.

Inputs

NameTypeRequiredDetails
ValuesList of Decimal numberYesNumbers to add.

Outputs

NameTypeDetails
ResultDecimal numberThe sum of the values.

Average​

Returns the arithmetic mean of a list of values. An empty list averages to 0.

Inputs

NameTypeRequiredDetails
ValuesList of Decimal numberYesNumbers to average.

Outputs

NameTypeDetails
ResultDecimal numberThe mean of the values.

Absolute value​

Returns the absolute value of a number.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number.

Outputs

NameTypeDetails
ResultDecimal numberThe absolute value.

Power​

Raises a base to an exponent.

Inputs

NameTypeRequiredDetails
BaseDecimal numberYesThe base value.
ExponentDecimal numberYesThe exponent.

Outputs

NameTypeDetails
ResultDecimal numberbase raised to exponent.

Square root​

Returns the square root of a non-negative number.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesNon-negative number. Minimum: 0.

Outputs

NameTypeDetails
ResultDecimal numberThe square root.

Random whole number​

Generates a random whole number between min and max (inclusive).

Inputs

NameTypeRequiredDetails
MinWhole numberYesMinimum value (inclusive).
MaxWhole numberYesMaximum value (inclusive).

Outputs

NameTypeDetails
ResultWhole numberThe random whole number.

Random decimal number​

Generates a random decimal number between min and max.

Inputs

NameTypeRequiredDetails
MinDecimal numberYesMinimum value (inclusive).
MaxDecimal numberYesMaximum value (exclusive).

Outputs

NameTypeDetails
ResultDecimal numberThe random number.

Text to whole number​

Reads a whole number from text. Returns an empty value if invalid.

Inputs

NameTypeRequiredDetails
TextTextYesThe text to read.

Outputs

NameTypeDetails
ResultWhole numberThe whole number, or empty. May be empty.

Text to decimal number​

Reads a decimal number from text. Returns an empty value if invalid.

Inputs

NameTypeRequiredDetails
TextTextYesThe text to read.

Outputs

NameTypeDetails
ResultDecimal numberThe decimal number, or empty. May be empty.

Convert to large whole number​

Turns text or a whole number into a big whole number, which stays exact at any size. Text may only contain digits, with an optional minus sign in front; anything else fails.

Inputs

NameTypeRequiredDetails
TextTextNoThe digits to read, for example 9007199254740993. Use this or Number. Use only one of these: Number.
NumberWhole numberNoA whole number to convert. Use this or Text. Use only one of these: Text.

Outputs

NameTypeDetails
Large whole numberLarge whole numberThe big whole number.

Large whole number to whole number​

Turns a big whole number into a normal whole number for the other math actions. Fails when the number is too large to stay exact as a normal number (beyond about 9 quadrillion).

Inputs

NameTypeRequiredDetails
Large whole numberLarge whole numberYesThe big whole number to convert.

Outputs

NameTypeDetails
Whole numberWhole numberThe same number as a normal whole number.

Calculate with large whole numbers​

Adds, subtracts, multiplies, divides or takes the remainder of two big whole numbers, exactly, and compares them. Dividing by zero fails.

Inputs

NameTypeRequiredDetails
aLarge whole numberYesThe first large whole number.
OperationLarge whole number operationYesWhat to calculate. Default: Add.
bLarge whole numberYesThe second large whole number.

Outputs

NameTypeDetails
ResultLarge whole numberThe result of the operation.
ComparisonWhole number-1 when a is smaller than b, 0 when they are equal, 1 when a is larger.

Format whole number​

Converts a whole number to a text.

Inputs

NameTypeRequiredDetails
ValueWhole numberYesThe whole number.

Outputs

NameTypeDetails
ResultTextThe text representation.

Format decimal number​

Formats a number with a fixed number of decimal places.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number.
DecimalsWhole numberYesNumber of decimal places (0-20). Value: 0 to 20. Default: 2.

Outputs

NameTypeDetails
ResultTextThe formatted text.

Human-readable number​

Formats a number for humans, following the locale's conventions: grouped with thousands separators (e.g. 4,000,000) or compact (e.g. 4M / 4 million). Defaults to the server's language.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe number to format.
StyleNumber styleYesHow the number is rendered: grouped (thousands separators) or compact (abbreviated). Default: Grouped.
DecimalsWhole numberNoOptional number of decimal places (0-20). Grouped style shows exactly this many; compact styles show at most this many (default 1). Value: 0 to 20.
LocaleTextNoLocale whose number conventions are used, e.g. "en" or "de". Defaults to the server's language.

Outputs

NameTypeDetails
TextTextThe formatted number, e.g. "4,000,000" or "4M".

Logarithm​

Returns the logarithm of a value. Leave the base empty for the natural logarithm (base e). The value must be greater than 0.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe value to take the logarithm of (must be greater than 0).
BaseDecimal numberNoLogarithm base. Leave empty for the natural logarithm (base e).

Outputs

NameTypeDetails
ResultDecimal numberThe logarithm of the value.

Exponential​

Returns e raised to the power of the value.

Inputs

NameTypeRequiredDetails
ValueDecimal numberYesThe exponent.

Outputs

NameTypeDetails
ResultDecimal numbere raised to the power of the value.
Need more help?
Can't find what you're looking for? Our team is happy to help.