Is there a formula or method of calculation that can be used when working
with Excel worksheets that can round the answer to the nearest multiple of
the answer, such as rounding for multiples of 10?

I am using Excel Office 2000