Use

The RoundUp() function returns a number rounded up to a given decimal point. If nothing is provided for the decimal point, 0 is assumed.

The number result given by RoundUp() is a new number stored at that value, as opposed to rounding with value formatting, which only changes how a number is displayed.

RoundUp() treats rounding up as rounding away from 0. For example, RoundUp(-7.3)  = -8.

Units

Numbers with units will be rounded based on those units. This means that the unit a number has at the point of calculation will affect the answer.

For example, RoundUp(5.8ft) and RoundUp(5.8 ft to mm) will return values that are not equal.

Examples

• RoundUp(1.8)  = 2
• RoundUp(1.2)  = 2
• RoundUp(-1.8)  = -2
• RoundUp(1.2222, 2)  = 1.23
• RoundUp(1.2222, 3)  = 1.223
• RoundUp(45133.1, -2)  = 45200
• RoundUp(3.2 ft)  = 4ft
• RoundUp(3.2 ft to cm)  = 98cm
• RoundUp(3.2 ft to cm) to ft  = 3.215 ft

Related functions

• Round()
• RoundDown()
• RoundSigFigs()

 

 

---

Function

RoundUp(value) value RoundUp(value, digits) value digits

---