Nearest Multiple Larger Than or Equal To X (CEILING)
Syntax: CEILING(Number; Significance; Mode)
The CEILING function rounds the given number up to the nearest multiple of significance equal to or greater than number itself. It is used in filtering noises out of a large number of values, spotting significant changes in values, detecting trend reversals, and similar tasks where it is easier to work with multiples of integers to get a better understanding of the sea of data you need to work with.
Figure 6-1. Sample results of the CEILING function
The CEILING function is also a great tool for solving mundane problems such as ordering the right ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
