Use numeric functions to return numeric values in a formula.
|
Function |
Syntax |
Description |
|---|---|---|
|
Ceil(num) |
num: A number |
Returns the smallest integer that is greater than or equal to a specified number. For example:
Ceil(14.2) |
|
Floor(num) |
num: A number |
Returns the largest integer that is not greater than a specified number. For example:
Floor(14.8) |
|
Log(num) |
num: A number |
Returns the natural logarithm of a specified number. For example:
Log(100) |
|
Log10(num) |
num: A number |
Returns the base 10 logarithm of a specified number. For example:
Log10(100) |
|
Mod(num, divisor) |
|
Returns the remainder of the division of a number by another number. For example:
Mod(15,2) |
|
Power(num, exponent) |
|
Raises a number to a power. The operator ^ (caret) can be used instead of this function. For example:
Power(2,3) |
|
Round(num, digits) |
|
Returns a numeric value, rounded to a specified number of decimal places. For example:
Round(14.81, 1) |
|
Sign(num) |
num: A number |
Returns -1 if a specified number is negative, 0 if the specified number is zero, or +1 if the specified number is positive. For example:
Sign(-2) |
|
ToText(num, digits) |
|
Converts a specified number to a string. The number is truncated to the specified number of decimal places. For example:
ToText(12.1451, 2) |
|
Truncate(num, digits) |
|
Returns a numeric value, truncated at a specified number of decimal places. For example:
Truncate(12.281, 1) |
| Temperature | Text |
|---|---|
| -2.01 | -2.0 |
| -1.06 | -1.1 |
| 0.08 | 0.1 |
| 1.07 | 1.1 |
| 2.08 | 2.1 |
| 3.99 | 4.0 |
| 5.00 | 5.0 |
| Temperature | Truncated |
|---|---|
| -2.01 | -2.00 |
| -1.06 | -1.00 |
| 0.08 | 0.00 |
| 1.07 | 1.00 |
| 2.08 | 2.00 |
| 3.99 | 3.90 |
| 5.00 | 5.00 |