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: