Forum Discussion
Solved
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
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))
