Difference between revisions of "Documentation/How Tos/Calc: ROUNDUP function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
Javier Lopez (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | + | {{Documentation/MasterTOC | |
+ | |bookid=1234''' | ||
+ | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
+ | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]] | ||
+ | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CEILING_function | ||
+ | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_ROUNDDOWN_function | ||
+ | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions | ||
+ | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions | ||
+ | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Trigonometric</div> | ||
+ | * [[Documentation/How_Tos/Calc:_COS_function|<div style="font-size: 120%;">Cos]] | ||
+ | * [[Documentation/How_Tos/Calc:_SIN_function|<div style="font-size: 120%;">Sin]] | ||
+ | * [[Documentation/How_Tos/Calc:_TAN_function|<div style="font-size: 120%;">Tan]] | ||
+ | * [[Documentation/How_Tos/Calc:_COT_function|<div style="font-size: 120%;">Cot]] | ||
+ | * [[Documentation/How_Tos/Calc:_ACOS_function|<div style="font-size: 120%;">Acos]] | ||
+ | * [[Documentation/How_Tos/Calc:_ACOT_function|<div style="font-size: 120%;">Acot]] | ||
+ | * [[Documentation/How_Tos/Calc:_ASIN_function|<div style="font-size: 120%;">Asin]] | ||
+ | * [[Documentation/How_Tos/Calc:_ATAN_function|<div style="font-size: 120%;">Atan]] | ||
+ | * [[Documentation/How_Tos/Calc:_ATAN2_function|<div style="font-size: 120%;">Atan2]] | ||
+ | * [[Documentation/How_Tos/Calc:_DEGREES_function|<div style="font-size: 120%;">Degrees]] | ||
+ | * [[Documentation/How_Tos/Calc:_RADIANS_function|<div style="font-size: 120%;">Radians]] | ||
+ | * [[Documentation/How_Tos/Calc:_PI_function|<div style="font-size: 120%;">Pi]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Hyperbolic</div> | ||
+ | * [[Documentation/How_Tos/Calc:_COSH_function|<div style="font-size: 120%;">Cosh]] | ||
+ | * [[Documentation/How_Tos/Calc:_SINH_function|<div style="font-size: 120%;">Sinh]] | ||
+ | * [[Documentation/How_Tos/Calc:_TANH_function|<div style="font-size: 120%;">Tanh]] | ||
+ | * [[Documentation/How_Tos/Calc:_COTH_function|<div style="font-size: 120%;">Coth]] | ||
+ | * [[Documentation/How_Tos/Calc:_ACOSH_function|<div style="font-size: 120%;">Acosh]] | ||
+ | * [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]] | ||
+ | * [[Documentation/How_Tos/Calc:_ASINH_function|<div style="font-size: 120%;">Asinh]] | ||
+ | * [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div> | ||
+ | * [[Documentation/How_Tos/Calc:_TRUNC_function|<div style="font-size: 120%;">Trunc]] | ||
+ | * [[Documentation/How_Tos/Calc:_ROUND_function|<div style="font-size: 120%;">Round]] | ||
+ | * [[Documentation/How_Tos/Calc:_ROUNDDOWN_function|<div style="font-size: 120%;">Rounddown]] | ||
+ | * [[Documentation/How_Tos/Calc:_ROUNDUP_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Roundup]] | ||
+ | * [[Documentation/How_Tos/Calc:_CEILING_function|<div style="font-size: 120%;">Ceiling]] | ||
+ | * [[Documentation/How_Tos/Calc:_FLOOR_function|<div style="font-size: 120%;">Floor]] | ||
+ | * [[Documentation/How_Tos/Calc:_EVEN_function|<div style="font-size: 120%;">Even]] | ||
+ | * [[Documentation/How_Tos/Calc:_ODD_function|<div style="font-size: 120%;">Odd]] | ||
+ | * [[Documentation/How_Tos/Calc:_MROUND_function|<div style="font-size: 120%;">Mround]] | ||
+ | * [[Documentation/How_Tos/Calc:_INT_function|<div style="font-size: 120%;">Int]] | ||
+ | * [[Documentation/How_Tos/Calc:_QUOTIENT_function|<div style="font-size: 120%;">Quotient]] | ||
+ | * [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Logarithm/Powers</div> | ||
+ | * [[Documentation/How_Tos/Calc:_EXP_function|<div style="font-size: 120%;">Exp]] | ||
+ | * [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]] | ||
+ | * [[Documentation/How_Tos/Calc:_LOG_function|<div style="font-size: 120%;">Log]] | ||
+ | * [[Documentation/How_Tos/Calc:_LN_function|<div style="font-size: 120%;">Ln]] | ||
+ | * [[Documentation/How_Tos/Calc:_LOG10_function|<div style="font-size: 120%;">Log10]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Bessel functions</div> | ||
+ | * [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]] | ||
+ | * [[Documentation/How_Tos/Calc:_BESSELJ_function|<div style="font-size: 120%;">Besselj]] | ||
+ | * [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]] | ||
+ | * [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div> | ||
+ | * [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]] | ||
+ | * [[Documentation/How_Tos/Calc:_COMBIN_function|<div style="font-size: 120%;">Combin]] | ||
+ | * [[Documentation/How_Tos/Calc:_COMBINA_function|<div style="font-size: 120%;">Combina]] | ||
+ | * [[Documentation/How_Tos/Calc:_CONVERT_function|<div style="font-size: 120%;">Convert]] | ||
+ | * [[Documentation/How_Tos/Calc:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUNTBLANK_function|<div style="font-size: 120%;">Countblank]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUNTIF_function|<div style="font-size: 120%;">Countif]] | ||
+ | * [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]] | ||
+ | * [[Documentation/How_Tos/Calc:_ERF_function|<div style="font-size: 120%;">Erf]] | ||
+ | * [[Documentation/How_Tos/Calc:_ERFC_function|<div style="font-size: 120%;">Erfc]] | ||
+ | * [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]] | ||
+ | * [[Documentation/How_Tos/Calc:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]] | ||
+ | * [[Documentation/How_Tos/Calc:_GCD_function|<div style="font-size: 120%;">Gcd]] | ||
+ | * [[Documentation/How_Tos/Calc:_GCD_ADD_function|<div style="font-size: 120%;">Gcd Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_GESTEP_function|<div style="font-size: 120%;">Gestep]] | ||
+ | * [[Documentation/How_Tos/Calc:_ISEVEN_function|<div style="font-size: 120%;">Iseven]] | ||
+ | * [[Documentation/How_Tos/Calc:_ISODD_function|<div style="font-size: 120%;">Isodd]] | ||
+ | * [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]] | ||
+ | * [[Documentation/How_Tos/Calc:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_MULTINOMIAL_function|<div style="font-size: 120%;">Multinomial]] | ||
+ | * [[Documentation/How_Tos/Calc:_PRODUCT_function|<div style="font-size: 120%;">Product]] | ||
+ | * [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]] | ||
+ | * [[Documentation/How_Tos/Calc:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]] | ||
+ | * [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]] | ||
+ | * [[Documentation/How_Tos/Calc:_SIGN_function|<div style="font-size: 120%;">Sign]] | ||
+ | * [[Documentation/How_Tos/Calc:_SQRT_function|<div style="font-size: 120%;">Sqrt]] | ||
+ | * [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUBTOTAL_function|<div style="font-size: 120%;">Subtotal]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUM_function|<div style="font-size: 120%;">Sum]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]] | ||
+ | }}__TOC__ | ||
== ROUNDUP == | == ROUNDUP == |
Revision as of 07:47, 1 June 2013
CALC FUNCTIONS
- Mathematical FunctionsTrigonometric
- CosSinTanCotAcosAcotAsinAtanAtan2DegreesRadiansPiHyperbolic
- CoshSinhTanhCothAcoshAcothAsinhAtanhRounding and remainders
- TruncRoundRounddownRoundupCeilingFloorEvenOddMroundIntQuotientModLogarithm/Powers
- ExpPowerLogLnLog10Bessel functions
- BesseliBesseljBesselkBesselyMiscellaneous
- AbsCombinCombinaConvertConvert AddCountblankCountifDeltaErfErfcFactFactdoubleGcdGcd AddGestepIsevenIsoddLcmLcm AddMultinomialProductRandRandbetweenSeriessumSignSqrtSqrtpiSubtotal
Contents
ROUNDUP
Rounds a number up, away from zero, to a certain precision.
Syntax:
ROUNDUP(number; places)
- returns number rounded up (away from zero) to places decimal places. If places is omitted or zero, the function rounds up to an integer. If places is negative, the function rounds up to the next 10, 100, 1000, etc.
Example:
ROUNDUP(1.1111; 2)
- returns 1.12
ROUNDUP(1.2345; 1)
- returns 1.3
ROUNDUP(45.67; 0)
- returns 46
ROUNDUP(-45.67)
- returns -46
ROUNDUP(987.65; -2)
- returns 1000
If these examples do not seem to work, see Tools - Options - OpenOffice.org Calc - Calculate to check the display precision.
Template:Documentation/SeeAlso
-