Kutools for Excel 26.10 HOT
300+ Powerful Features You Must Have in Excel
Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combining sheets quickly, merging cells without losing data, pasting to only visible cells, counting cells by color and so on. 300+ powerful features / functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 or Office 365!
Office Tab 14.50HOT
Adding Tabbed Interface for Office
It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2021, 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo
Kutools for Outlook 16.00NEW
100+ Powerful Features for Outlook
Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2021, 2019, 2016, 2013, 2010 or Office 365!
Kutools for Word 10.00NEW
100+ Powerful Features for Word
Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2021, 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!
Quickly round cell values without formula in Excel
Kutools for Excel
Sometimes we may need to round the cell values up or down in Excel. But using the roundup or round down formula, they won’t change the actual values of cells after rounding. With Round utility of Kutools for Excel, you can easily apply the following operations:
- Rounding a range of values and display the actual values without formula
- Rounding up a range of values and display the actual values without formula
- Rounding down a range of values and display the actual values without formula
- Rounding a range of values to even and display the actual values without formula
Click Kutools >> Round. See screenshot:
 |
 |
 |
Usage:
1. Select the range that you want to round the numbers.
2. Then apply the utility by clicking Kutools > Round, and specify the rounding option and decimal place digits in the Round Without Formula dialog box. See screenshot:
3. Click Ok to apply the operation.
Notes:
Rounding: the same as the =ROUND(number, num_digits) formula. For example, if the cell value is 23.56, and you set the decimal place digits to 1, and the value will be 23.6 after rounding. See screenshots:
Rounding Up: the same as the =ROUNDUP(number, num_digits) formula. For example, if the cell value is 45.23, and you set the decimal place digits to 1, and the value will be 45.3 after rounding up. See screenshots:
Rounding Down: the same as the =ROUNDDOWN(number, num_digits) formula. For example, if the cell value is 38.49, and you set the decimal place digits to 1, and the value will be 38.4 after rounding down. See screenshots:
Rounding to Even: For example, if the cell value is 7.55, and you set the decimal place digits to 1, the value will be 7.6 after rounding. But if the cell value is 8.65, the cell value will be 8.6 after rounding. See screenshots:
Demo: Round / Round down / Round up a range of cells
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.
