=ROUND(C4/10,0)*10

--
Ian
--
"rollover22" wrote in message
...
I am trying to convert numbers to roundup and also to rounddown depending
on
5. I thought maybe I can use the "=IF(C4(____5),rounddown,roundup), now
I
know I am not an Excel guru, as you can see, I have trouble just putting
the
IF THEN formula here.

So how I have a script to change, oh say around 100K entries to a rounded
numeral. Again no decimals are being used, I want 4507 to 4510 and 4503
to
4500.

Thank you
rollingover22