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