Excel Rounding Matric

Well, a bit more psychology then maths driven scheme. I think that achieving this with standard formula would be quite painful, so wrote UDF to deal with it:

Please Login or Register  to view this content.

One can either use it as standard worksheet function (macros has to be enabled)

Please Login or Register  to view this content.

or within own macro.

See attached file.