MROUND is a built-in function in Excel that round a number to a specific multiple.
eg. =MROUND(21,5) rounds 21 to the nearest multiple of 5, which gives 20.
For some reason this function is not available in my Excel (2003) and so i thought it may be useful to write the function myself using VBA. However i'm not very familiar with VBA so can someone please help me to kick start my first VBA function.
ps. i've found out after that to add the function all i have to do is go Tools --> Add-ins and tick Analysis ToolPak in the dialog box.
Microsoft ISV Community Center Forums2