Sorry, I misread the question...

Maybe...

=ROUND(A1/5,0)*5
or
=ROUND(YourFormulaHere/5,0)*5



kjcramp wrote:

The second choice with the formula works, although it rounds up if there
is any value behind the decimal at all, but it's close enough.

Thanks again!

--
kjcramp
------------------------------------------------------------------------
kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753
View this thread: http://www.excelforum.com/showthread...hreadid=531548

--

Dave Peterson