How to Round Numbers in Excel
In today's lesson, you will learn how to round numbers in Excel.
We have a list of numbers ready for this tutorial. To round numbers in Excel, we need to type a formula. Put the mouse pointer in the empty cell next to the number you need and type the formula. You can find it in the description box below.
The formula: =roundup(Select the cell with a number,0) Press Enter. Zero in the formula stands for how many numbers you want to see after a comma. You will see the roundup of your number.
Let's round up another number, but this time let's round up keeping 2 symbols after a comma. Type the formula =roundup(Select the cell with a number,2). Press 'Enter'. You will see a roundup of the number.
If you want to get a round number type '1' in the formula. It will go like this: =roundup(Select the cell with a number,1). Press 'Enter'.
Видео How to Round Numbers in Excel канала HOWZA TUTORIALS
We have a list of numbers ready for this tutorial. To round numbers in Excel, we need to type a formula. Put the mouse pointer in the empty cell next to the number you need and type the formula. You can find it in the description box below.
The formula: =roundup(Select the cell with a number,0) Press Enter. Zero in the formula stands for how many numbers you want to see after a comma. You will see the roundup of your number.
Let's round up another number, but this time let's round up keeping 2 symbols after a comma. Type the formula =roundup(Select the cell with a number,2). Press 'Enter'. You will see a roundup of the number.
If you want to get a round number type '1' in the formula. It will go like this: =roundup(Select the cell with a number,1). Press 'Enter'.
Видео How to Round Numbers in Excel канала HOWZA TUTORIALS
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to change Line Spacing in WordHow to Hide Desktop Icons in Windows 10How to Change the Default Font in ExcelHow to Write Subscript and Superscript in Microsoft Excel DocumentHow to Share Folder in macOS | Folder Sharing on MacHow to Combine Data in ExcelHow to Add or Remove Startup Programs in macOSHow to Change User Name in macOSHow to Set Up Email Account in OutlookHow to Save a Picture from a Microsoft Word documentHow to Partition a HDD / SSD in macOSHow to Set Password on Windows 10 | How to Put a Password on Windows 10How to Insert Section Breaks in a WordHow to Delete Duplicate Entries in Excel | How to Remove Duplicate Entries in ExcelHow to Show Developer Tab in Excel | How to Enable the Developer Tab in Microsoft ExcelHow to Search Duplicates in ExcelHow to Add a Signature in Outlook | Create a Signature in OutlookКак Снять Защиту с PDF Файла | Как Снять Пароль с PDF ФайлаКак Поставить Защиту на PDF Файл | Как Установить Пароль на PDF файлКак Показать Расширение Файлов Windows 10, 7, 8