Fabric Plan Community Logo
Sign in

MROUND

The MROUND function rounds a number to the nearest multiple of a specified value. It adjusts the input number up or down to the closest multiple based on the given significance. This function is commonly used in financial calculations, pricing, and quantity adjustments where values must align with defined increments.

Syntax

MROUND(value, multiple)

Arguments

  • value: The number to round.
  • multiple: The multiple to which the number is rounded.

Return value

Returns the number rounded to the nearest specified multiple.

Example

MROUND(Planned Units, 5)

In the example below, the Rounded Planned Units measure is created using the MROUND function, which rounds the Planned Units values to the nearest multiple of 5.

Excel equivalent

MROUND

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.