writer
6,694
edits
Changes
Jump to navigation
Jump to search
Manuals/calci/CEILINGAT (view source)
Revision as of 19:21, 21 September 2017
, 19:21, 21 September 2017Created 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..."
<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.
==Description==
*This function round a number up to the nearest specified multiple.
*In <math>CEILINGAT(number,significance)</math>,<math>number</math> is the number to be rounded.
*<math>Significance</math> 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==
1.CEILINGAT([5,60,32.3],25) = 25 75 50
2.CEILINGAT(1600,30) = 1620
3.CEILINGAT(56.321,7) = 63
==See Also==
*[[Manuals/calci/MROUND | MROUND]]
*[[Manuals/calci/CEILING | CEILING]]
*[[Manuals/calci/ROUNDUP | ROUNDUP]]
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]]
==References==
*[https://exceljet.net/excel-functions/excel-ceiling-function Ceiling Function]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>Array</math> is the set of values.
*<math>MaxNumber</math> is the upper limit value.
==Description==
*This function round a number up to the nearest specified multiple.
*In <math>CEILINGAT(number,significance)</math>,<math>number</math> is the number to be rounded.
*<math>Significance</math> 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==
1.CEILINGAT([5,60,32.3],25) = 25 75 50
2.CEILINGAT(1600,30) = 1620
3.CEILINGAT(56.321,7) = 63
==See Also==
*[[Manuals/calci/MROUND | MROUND]]
*[[Manuals/calci/CEILING | CEILING]]
*[[Manuals/calci/ROUNDUP | ROUNDUP]]
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]]
==References==
*[https://exceljet.net/excel-functions/excel-ceiling-function Ceiling Function]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]