CEILING

This script will return a num­ber which has the num­ber round­ed up to the spec­i­fied num­ber of dig­its from the dec­i­mal point.

FORMAT: CEILING (number, number of digits)

---

DEFINITIONS:

• Num­ber: Numer­i­cal expres­sion to indicate the num­ber of dig­its.

If pos­i­tive the num­ber of dig­its to show at the right of the dec­i­mal point. If neg­a­tive the num­ber of dig­its to the left of the dec­i­mal point start­ing at tens.

---

EXAMPLE 1:

show CEILING (34.23001, 2)

Shows 34.24

EXAMPLE 2:

show CEILING (3423.456, -2)

Shows 3,500