• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

ROUNDUP Function in Excel

The Excel ROUNDUP function is used to round a number up to a specified number of digits.For example, round a number up to one decimal place.

The syntax for the ROUNDUP function is:

=ROUNDUP(number,num_digits)

ArgumentPurpose
NumberThe number you want to round up
num_digitsThe number of digits you want to round the number up to. If the num_digits is greater than 0, the number is rounded up to the specified number of decimal points. If the num_digits is 0, the number is rounded up to the nearest integer. If num_digits is less than 0, the number is rounded up to the left of the decimal point.

Below are examples of the ROUNDUP function being used to round numbers up to a various number of digits.

ROUNDUP function in Excel to round up to a specified number of digits
FunctionResult
=ROUNDUP(A1,2)5.33
=ROUNDUP(A2,0)3
=ROUNDUP(A3,1)4.6
=ROUNDUP(A4,-1)30

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • How to Hyperlink to a Hidden Worksheet in Excel
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·