Marks PC Solution

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