MROUND from Excel

Another just discovered built in function of Excel.

 

I think this is useful for all that works with figures… like myself, I am exploring this function when I try to create set of numbers with a multiple of a required figures.  Eg. To simulate data for production, your company will have minimum figure to start.  Eg. Might be a multiple of 100

 

So, to tell excel to create multiple of 100 figures upon your computation/eg. Proportions, you can use this formula.  It’s =MROUND (“calculations here”,100).

 

This is a helpful discovery for myself.  I am not sure if it’ll benefit you.