SOLVED

New Contributor

# MRound Function with an existing formula

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

# Re: MRound Function with an existing formula

If you now have a formula

=expression

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)

# Re: MRound Function with an existing formula

I have this formula now that I want to add the mround function to-
=IF(AN2=0,"",AN2/(1-\$AU\$1))
best response confirmed by Sergei Baklan (MVP)
Solution

# Re: MRound Function with an existing formula

That would be

=IF(AN2=0,"",MROUND(AN2/(1-\$AU\$1),5))

Change 5 to the desired precision.

# Re: MRound Function with an existing formula

That worked! Thank you for your help!