CEILING function
This topic describes the formula syntax and usage of the CEILING function in the Data Quality Execute Formula transform.
Description
Rounds a number to the nearest integer or to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula CEILING(4.42,0.05) to round prices up to the nearest nickel.
Syntax
CEILING(number, significance)The CEILING function syntax has the following arguments:
- number Required. The value you want to round.
- significance Required. The multiple to which you want to round.
Notes
- If number is nonnumeric, an error occurs.
- Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs
- If number is negative, and significance is negative, the value is rounded down, away from zero.
- If number is negative, and significance is positive, the value is rounded up towards zero.
Example
Data: 2.5, -2.5, -2.5, 1.5, 0.234 in the Number field.
| Formula | Description | Result |
|---|---|---|
CEILING([Number],1) |
Rounds 2.5 up to nearest multiple of 1 | 3 |
CEILING([Number],-2) |
Rounds -2.5 up to nearest multiple of -2 | -4 |
CEILING([Number],-2) |
Rounds -2.5 up to nearest multiple of 2 | -2 |
CEILING([Number],0.1) |
>Rounds 1.5 up to nearest multiple of 0.1 | 1.5 |
CEILING([Number],0.01) |
Rounds 0.234 up to the nearest multiple of 0.01 | 0.24 |