Roundn Function

The standard ROUND function allows you to round to a particular decimal point.  Roundn is a function I use all the time that allows you to round to any number.  Below is the code:

Public Function roundn(Number As Double, RoundTo As Double) As Double
    roundn = Round(Number / RoundTo, 0) * RoundTo
End Function

In Excel, this function could be used to calculate the following:

=roundn(123456,500) = 123,500
=roundn(1234.5678,.0005) = 1,234.55
=roundn(1000/3,0.25) = 333.25

Welcome to Office Add-Ins

Office Add-Ins has opened its doors...

Welcome to Office Add-Ins.  The function of this site is to provide insight, useful snippits of VBA code, and original and third-party MS Office add-ins.

Check back soon for updates.