Free Excel Tutorial for Engineers : Mathematics & Statistics



The round function in excel allows you to round of the number to its nearest whole number or reduce the number of decimal points in the number. The syntax for the “ROUND” function is =ROUND(Number,Num_digits) Number – It is the number to be rounded - it can also be a formula or a cell reference to a number or formula. Num_digits – It is the number of digits or the number of decimal places that the number is to be rounded to. For example, if all the coordinates shown in the report have multiple decimal points you can round the numbers to a fixed number of decimal points. If the X Coordinate in C3 is 549.5091, you can reduce the decimal points to 2 decimal places by using the formula [=ROUND(C3,2)]

150.png

MROUND: The MROUND function allows you to round the number or the decimal points to the nearest specified multiple. The syntax for the MROUND function is = MROUND(Number,Multiple) Number – It is the value to be rounded. Multiple – It is required multiple. The function rounds the Number specified above up or down to the nearest multiple of this value. The number is rounded up if the last digit is greater than or equal to 5. If it is less than 5, the number is rounded down. For example, if you want to round the X coordinate 549.5091 as shown in C3 in your report to the nearest 5 you can use the formula [=MROUND(C3,5)] This will give you the result as 550.

151.png

MAX: MAX is one of the statistical functions in excel to find the largest number in the list of numbers. For example, if you have values from C3 to E25 you can use the max function to find the largest number by using the formula [=MAX(C3:E25)]

152.png

MIN: The MIN function allows you to find the smallest number in range of cells. For example, if you want to find the smallest value from the values entered in cells C3 to E25, then you can use the formula [=MIN(C3:E25)]

153.png