• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

5 simple and most detailed ways to round numbers in Excel

January 6, 2024 by admin Category: Tech

You are viewing the article 5 simple and most detailed ways to round numbers in Excel  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

In some Excel use cases, you will need to round to the nearest number because the decimal value is negligible, or you will need the data to be an integer to simplify the calculation. Tnhelearning.edu.vn will share with you 5 simple ways to round numbers in Excel.

Table of Contents

  • Round numbers by adding number formatting
  • Use the function to round numbers up
  • Using the Function Rounds Numbers Down
  • Function that rounds a number to the nearest number
  • How to round with ODD and EVEN . functions

Round numbers by adding number formatting

Step 1: Select the cell/range you want to format, then select General on the toolbar

5 simple and most detailed ways to round numbers in Excel

Step 2: Select More Number Formats.

Chọn More Number Formats

Step 3: Choose the appropriate format, such as Currency (Currency), Accounting (Accounting), Percentage ,…

Step 4: Enter the number of decimal places you want to display in the Decimal places box .

Chọn định dạng phù hợp và nhập số chữ số sau dấu thập phân

In addition, you can also do it quickly using the Increase Decimal or Decimal tool in the toolbar.

Sử dụng công cụ Tăng hoặc Giảm thập phân

Use the function to round numbers up

The ROUNDUP function is used to round a number up, away from zero (zero).

For example, =ROUNDUP(3.275, 1) means rounding the number 3.275 up to 1 decimal place. The displayed result will be 3.3.

Hàm ROUNDUP

Using the Function Rounds Numbers Down

The ROUNDDOWN function is used to round a number down to zero (zero).

READ More:   What is a chainsaw? Structure and working principle of chainsaw

For example, =ROUNDDOWN(3.275,1) means rounding the number 3,275 down to 1 decimal place. The displayed result will be 3.2.

Hàm ROUNDDOWN

Function that rounds a number to the nearest number

The ROUND function is used to round a number to the nearest number of decimal places specified.

For example, =ROUND(3.275,2) means rounding the number 3.275 to 2 decimal places. The displayed result will be 3.28.

Hàm ROUND

How to round with ODD and EVEN . functions

ODD . function

The ODD function is used to round up to the nearest odd integer, away from 0 (zero).

For example, =ODD(3.275) means rounding the number 3.275 up to the nearest odd integer. The displayed result will be 5.

Hàm ODD

When using the ODD function, regardless of the sign of the number, the value is always rounded up according to the principle away from zero (zero). If the number is an odd integer, no rounding will occur.

For example, =ODD(-3.275) means rounding -3.275 up to the nearest odd integer. The displayed result will be -5.

Hàm ODD trả về kết quả số nguyên ra gần nhất ra xa số 0

EVEN . function

The EVEN function is used to round up to the nearest even integer, away from zero (zero).

For example, =EVEN(3.275) means rounding the number 3.275 up to the nearest even integer. The displayed result will be 4.

Hàm EVEN

Similarly, when using the EVEN function, regardless of the sign of the number, the value is always rounded up according to the principle away from zero (zero). If the number is an even integer, no rounding will occur.

The article has shown you 5 ways to round numbers in Excel in the most detail. Hope you are succesful.

READ More:   Top 4 cheapest smartphones on the market

Thank you for reading this post 5 simple and most detailed ways to round numbers in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

Related Search:

Related Posts

How to make delicious, crispy, delicious garlic butter shrimp, simple and easy to do
How to make delicious, crispy, delicious garlic butter shrimp, simple and easy to do
How to make crispy, delicious and simple vinegar dipped squid
How to make crispy, delicious and simple vinegar dipped squid
How to make durian ice cream with a simple blender at home
How to make durian ice cream with a simple blender at home

Category: Tech

Previous Post: « Top 999+ easy acrylic painting images – Amazing Collection easy acrylic painting images Full 4K
Next Post: Top 999+ good night images in hindi shayari – Amazing Collection good night images in hindi shayari Full 4K »

Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge