SOLVED

MRound Function with an existing formula

Copper 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

@Claunch44 

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)

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 VI_Migration (Silver Contributor)
Solution

@Claunch44 

That would be

 

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

 

Change 5 to the desired precision.

@Hans Vogelaar 

That worked! Thank you for your help!

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Claunch44 

That would be

 

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

 

Change 5 to the desired precision.

View solution in original post