CEILING function

CEILING rounds a number up to the nearest multiple of significance.

Syntax

CEILING(number,increment,mode)

Important: If both number and increment are negative and the mode value is equal to zero or is not given, the results in IBM Docs and Microsoft Excel differ after the import is complete. If you export the spreadsheet to Excel, use mode=1 to see the same results in Excel as in IBM Docs.

Example

=CEILING(-11,-2) returns -10.

=CEILING(-11,-2,0) returns -10.

=CEILING(-11,-2,1) returns -12.




Trademarks | IBM Connections wiki