Jan 20 2023 07:36 AM
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?
Jan 20 2023 08:17 AM
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)
Jan 20 2023 08:39 AM
Jan 20 2023 08:42 AM
SolutionJan 20 2023 04:06 PM
That worked! Thank you for your help!