MRound Function with an existing formula

New Contributor

Cell A has a margin amount. Cell B is my budget amount. Cell C is my sales amount (budget with margin). I want the mround function to also be in cell C. 

So how do I add the mround function to a cell that already has the formula to calculate my budget plus margin?

4 Replies


If you now have a formula




you can change it to


=MROUND(expression, precision)


For example, if the formula is =A2+B2 and you want to round to the nearest multiple of 5, use =MROUND(A2+B2, 5)

I have this formula now that I want to add the mround function to-
best response confirmed by Sergei Baklan (MVP)


That would be




Change 5 to the desired precision.

@Hans Vogelaar 

That worked! Thank you for your help!