Do you mean round to the nearest increment of 5?

One way:

A1 = some number

=ROUND(A1/5,0)*5

--
Biff
Microsoft Excel MVP


"Ashley" wrote in message
...
How do I round a number to the nearest 5th using Excel 2003?
HELP!