Difference between revisions of "Manuals/calci/CEILINGAT"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''CEILINGAT (Array,MaxNumber) '''</div><br/> *<math>Array</math> is the set of values. *<math>MaxNumber</math> is the upper limit value. ==Descri...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 14: | Line 14: | ||
==Examples== | ==Examples== | ||
| − | + | # CEILINGAT([5,60,32.3],25) = 25 75 50 | |
| − | + | # CEILINGAT(1600,30) = 1620 | |
| − | + | # CEILINGAT(56.321,7) = 63 | |
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|2kQZ_i3VGn0|280|center|CEILING}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:00, 10 December 2018
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.
Examples
- CEILINGAT([5,60,32.3],25) = 25 75 50
- CEILINGAT(1600,30) = 1620
- CEILINGAT(56.321,7) = 63