### Rounding Numbers in MS 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 . . .

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.

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 . . .

### 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 ALLCARSGOB