=MROUND(A2,5)
If it gives you a #NAME! error, look up MROUND in Excel help.
--
David Biddulph

"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.