CEILING

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)

• Number is the value you want to round.
• Significance is the multiple to which you want to round.

Remarks:

• Both arguments must be numerical.
• 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.
• Number and Significance must have the same signs.

• When used in an event analysis flowchart, the parameters must evaluate to numerical values. They can include:

• Numerical values

• Standard operands (+, -, *, /)

• Predefined mathematical functions (exp, log, sin, etc.)

• Event analysis internal functions

• Event analysis resources

• References to any ReliaSoft Workbooks

Example:

• CEILING(2.5, 1) = 3 [rounds 2.5 up to nearest multiple of 1]
• CEILING(-2.5, -2) = -4 [rounds -2.5 up to nearest multiple of -2]
• CEILING(-2.5, 2) returns an error, because -2.5 and 2 have different signs!