CEILING

See also A-Z Spreadsheet Function List

Description Rounds a number up to the nearest multiple of a specified significance.

Syntax CEILING(number, significance)

number is the value to round.

significance is the multiple to which to round.

Remarks Regardless of the sign of the number, the value is rounded up, away from zero. If number is an exact multiple of significance, no rounding occurs.

         If number or significance is non-numeric, #VALUE! is returned. When the arguments have opposite signs, #NUM! is returned.

See Also EVEN , FLOOR , INT , ODD , ROUND , and TRUNC functions

Examples CEILING(1.23459, .05) returns 1.25

         CEILING(-148.24, -2) returns -150