Forum Discussion

Copper Contributor

Jan 20, 2023

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 cel...

excel

Formulas and Functions

HansVogelaar
Jan 20, 2023
Claunch44

That would be

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

Change 5 to the desired precision.

Claunch44

Copper Contributor

Jan 20, 2023

I have this formula now that I want to add the mround function to-
=IF(AN2=0,"",AN2/(1-$AU$1))

HansVogelaar

MVP

Jan 20, 2023

Claunch44

That would be

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

Change 5 to the desired precision.

Claunch44
Copper Contributor
Jan 21, 2023
HansVogelaar
That worked! Thank you for your help!