All functions / Math

ROUNDUP

Rounds a number away from zero.

Syntax

=ROUNDUP(number, num_digits)

Arguments

• number: The number to use.
• num_digits: Digits after the decimal point.

Example

=ROUNDUP(3.141, 1) → 3.2

Practise it

• Rounding values (not just how they look)
• Weeks, months and quarters in reports
• Payoff time, true rates and savings targets