Excel: Round up to whole numbers

With a small formula you can round up to whole numbers in Excel. We will show you which settings you have to make for this.

Round up with Excel - so it'll work

• Select the cell whose numbers you want to round up.
• Now enter "= Round up (A1, 0)" (without spaces).
• For A1, you need to insert the value or cell link to be rounded. The "0" stands for the number of decimal places.

We have summarized tips for calculating with formulas here.