In this blog, you can also use how to round numbers in Excel without formula. The EVEN function works in the same way as ODD, but returns the next even integer after rounding away from zero.Įxtra Method: Use the Excel Formatting Options
The ODD function just requires the number to round.
The ODD function returns the next odd integer after rounding a number away from zero.īoth positive and negative numbers are rounded away from zero, so positive numbers get bigger, and negative numbers become smaller. To get only the decimal portion of the number you could do However, they differ in the way that TRUNC will simply truncate the integer portion, whilst INT will round down to the nearest integer. The TRUNC function is commonly used to extract the integer part of a number, just like the INT function. Specifying the number of digits to truncate to is optional, and if not specified 0 is used. To use the TRUNC function you need to provide the number to truncate, and the number of digits to truncate to. Technically this is not a rounding function, but I feel it deserves to be spoken about along with these other functions. The TRUNC function extracts the part of a number specified by a given number of digits. The MROUND function requires the number you want to round, and the multiple to round it to.Ĭheck out this video of the MROUND function being used to round a time to the nearest 15 minutes. Round a time to the nearest 30 minutes.The MROUND function returns a number rounded to a specified multiple.įor example, this function can be used to Now that you have learned how to round numbers in Excel, let’s move to related function – MROUND. The ROUNDDOWN function returns a number rounded down to a specified number of places. The ROUNDUP function returns a number rounded up to a specified number of places. The ROUND function will round a number of 5-9 up, and a number of 1-4 down. You can also enter 0 to simply round to the nearest integer. You can enter a positive or negative value for num_digits as shown in the examples below.Ī positive value rounds to the right of the decimal point, and a negative value rounds to the left of the decimal point (i.e. The number is the number that you want to round, and then num_digits is how many digits you want to round the value to. So whether you want to round to a specific number of decimals, or to the nearest hundredth, the ROUND function can help. You can round a number to the right or left of the decimal point. The ROUND function in Excel will return a number rounded to a specified number of digits.
FREE FORMULAS & VLOOKUP WEBINAR - REGISTER NOW » The ROUND Function