Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

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)

Remarks:

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.