Search results
MROUND returns a number rounded to the desired multiple. MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. The Number and Multiple arguments must have the same sign.
The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple.
11 paź 2024 · Funkcja MROUND zwraca liczbę zaokrągloną do najbliższej określonej wielokrotności. Składnia. =MROUND (number, multiple) Argumenty. numer (wymagane): Liczba do zaokrąglenia. wielokrotne (wymagane): Liczba, do której chcesz zaokrąglić numer. Wartość zwracana. Funkcja MROUND zwraca wartość liczbową. Uwagi dotyczące funkcji.
3 maj 2023 · The MROUND function in Excel rounds a given number up or down to the specified multiple. Syntax : MROUND(number, multiple) Number - the value you want to round.
To round a number to the nearest given multiple (i.e. nearest dollar, nearest 5 dollars, etc.) you can use the MROUND function. In the example shown, the formula in D6 is: =MROUND(B6,C6)
The MROUND function in Excel is an inbuilt Math & Trig function that returns a number rounded to a multiple specified by the user. Users can use the function MROUND in Excel to remove the least significant digits in a number.
The MROUND function lets you round a value to the nearest multiple of another value. The syntax for the function is as follows: MROUND(value, factor) Here, value is the number you want to round. factor is the number, the multiple of which the value will be rounded to.