Google Sheets Function: MROUND

The MROUND function rounds a number to the nearest multiple of another number.


=MROUND(number, factor)

Round to 5 cents

In this example, the total cost is calculated using the formula:

google sheets function mround

To round the total to 5 cents, use the MROUND function and then enter the number (here, the total: B2*C2) and the factor 0.05.

The formula is therefore:

google sheets function mround total