About 5,000 years ago, the Sumerians developed a sexagesimal system – a base-60 system. However, this isn’t the only system that we use. You don’t talk about being in your 37s, for example. You talk about being in your 30s, and your 40s, and your 50s. After all, you tend to use it to talk about your age, negotiate your salary or even when you are estimating expenses. We can then state that our world is dominated by the base-10 system or the decimal system. Just think about when you want to lose a specific amount of weight or when you want to run a marathon at a certain pace. Besides, you also tend to consider a round number when you set specific goals for yourself.
And if you consider SAT takers, for example, it is also more likely to have takers retaking the test if they fall short of a round number. If you think about Major League players, it is 4 times more likely that they end a season with a. Besides, it is important to notice the influence that round numbers have on your life in other ways as well. After all, they are not only easy to process, easy to make sense of, as they are also simpler and easy to understand. The truth is that human beings prefer to use round numbers. But why is an hour 60 minutes and not 100? Why does an egg carton come with a dozen eggs and not with 10, for example? The truth is that there is a reason behind all these numbers that we keep using every day. For example, you know that there are 60 minutes in an hour, 12 eggs in a carton, and 360 degrees in a circle. When you are thinking about numbers, it is impossible not to think about those that we know represent fact. However, as you can imagine, some have had more importance than others.
The reality is that numbers have always been very important to humans since the earliest civilizations. While you already know what round numbers are, we believe that it is important that you understand how useful they are. Notice that you will also get an approximate result and not a precise one. So, this means that when you are rounding numbers you will be adjusting the digits either up or down to turn your calculations easier. You may learn more about the Round function in excel.Simply put, a rounded number has around the same value as the number that you started with. Similarly, use the -2 value for the num_digits argument for getting the nearest multiple of 100 for the given number.įor getting the nearest multiple of 1000, use the -3 value for num_digits argument. The example of nearest 100 by ROUND function You can see, I used -1 value for the num_digits argument of ROUND function to get the nearest multiple of 10.
#ROUNDING NUMBERS IN PLANSWIFT 10 HOW TO#
The first example shows how to get the nearest multiple of 10 by ROUND function. See the following examples of ROUND in action. You may also use the ROUND function of Excel to get the nearest multiples of 10, 100, 1000 etc. Getting the nearest multiple of 10 by ROUND function In the same way, you may get the nearest multiple of any number like 0.5, 2, 3, 10000, 10000 and so on by using the MROUND function. See the following example for getting the nearest multiple of 1000 for the given numbers: Nearest multiple of 1000 example by MROUND You can see, the nearest multiple of 99 is 100, 49 is 0, 1378 is 1400 etc. The formula for the nearest multiple of 100: Similarly, specify the value 100 as the second argument in the MROUND function for getting the nearest multiple of 100. =MROUND(A2,10) The example of getting nearest 100 In this example, the nearest multiple of 10 is displayed by using the MROUND function: Getting the nearest multiple of 10 by Excel MROUND The respective B cells display the nearest multiple of 5 where MROUND functions are used: In the example, I used different numbers in the A column of excel sheet. See the following example of getting the nearest multiple of 5 by using MROUND function. 24 is closer to 25 rather 20 and so on.The nearest multiple of 5 means the closest number that can be multiplied by 5. See the examples below for using the MROUND function. you may use the MROUND function in Excel. To get the nearest multiple for any number like 5, 10, 100 etc.