rounding numbers, with-out decimals. IE:4507 to 4510

[rollover22]

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

 

[Anne Troy]

Hi. This should work for you:
=round(a1,-1)
This rounds to the nearest 10. -1 is the decimal place, so if you want to
round to the nearest whole number, you put 0, if you want to round to the
nearest tenth, you put 1. But to round to the nearest 10, you put -1.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Ian]

=ROUND(C4/10,0)*10

--
Ian
--

I am trying to convert numbers to roundup and also to rounddown depending
on
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

 

[JE McGimpsey]

If you use ROUND() rather than ROUNDUP and ROUNDDOWN, then you'll get
results like:

=ROUND(4503,-1) ===> 4500
=ROUND(4505,-1) ===> 4510
=ROUND(4507,-1) ===> 4510

Is that what you want?