Skip to main content

Rounding Numbers in MS Excel

 

Rouding Numbers in Excel

 

If you work with fraction numbers in Excel then you might be familiar with this problem. While summing up fraction figures in Excel the result may vary from manual calculation. This happens because Excel counts every digits after the decimal point even if they don't appear on the screen! 

 

To fix this problem you can round the fraction numbers as per your requirements. Today I will talk about some simple ways to round the numbers. Hope this will solve your problem and save time as well . . .

 

Rounding the Numbers

First you should know that Excel has 03 formulas to round the numbers - 

  • Round
  • Rounddown
  • Roundup

Depending on your necessity you can choose any of them. Let's begin . . .

 

Rouding Numbers Formula in Excel

Now I'm begging your attention to the above image. I've tried to show all the formulas in a single worksheet. 

Look at the original numbers and their summation. And then look at the values of rounded numbers and their summations. There are some differences. Now it's your duty to decide which type of rounding you will follow. 

For accurate calculation I will suggest you to use normal rounding formula. But depending on your work, you can also choose between roundup and rounddown.

 

For your convenience I've also uploaded the project file in my Google Drive. You can download it from here - 

Project File (Rounding Numbers)

 

You should remember that this is just a basic tip for rounding numbers. There are many more advanced tasks to do in Excel. 

For example if you wanna round up before the decimal point then you can use a negative sign i.e. =Round(A2,-1) or =Round(A2,-2). But in that case your value should be 03 digits or more. 

 

Hopefully I will talk more about rounding next time. Thanks for staying with Marks PC Solution . . .  


 

Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...