Manuals/calci/CEILINGAT

CEILINGAT (Array,MaxNumber)

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of values.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaxNumber} is the upper limit value.

Description

This function round a number up to the nearest specified multiple.
In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle CEILINGAT(number,significance)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle number} is the number to be rounded.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Significance} is the multiple to use when rounding.
So this function returns a given number rounded up to a specified multiple.
Also this function always rounds up, away from zero.
CEILING works like the MROUND function, but CEILING always rounds up, away from zero.
CEILING can be a can be a useful function to set pricing after currency conversion, discounts, etc.
For example CEILINGAT(10,3) = 12.Here the number 10 is rounded near to the multiple of 3.