Skip to content
FormulaCraft

ROUNDUP

ROUNDUP forces rounding upward regardless of the digit that follows, unlike ROUND which rounds to nearest. Set the number of decimal places with the second argument.

Excel
=ROUNDUP(A2, 0)
Google Sheets
=ROUNDUP(A2, 0)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Value
12.1

=ROUNDUP(A2, 0)→13

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the number.
  2. 20 rounds to whole numbers.
  3. 312.1 rounds up to 13.

Need a version for your data?

Try: “Round the value in A2 up to a whole number”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: