Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rollover22
 
Posts: n/a
Default rounding numbers, with-out decimals. IE:4507 to 4510

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
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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


"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



  #3   Report Post  
Ian
 
Posts: n/a
Default

=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



  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?


In article ,
"rollover22" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding numbers to the nearest 5 or 0 Fieldmedic Excel Worksheet Functions 3 July 17th 05 07:51 AM
Rounding Numbers jack aubrey Excel Discussion (Misc queries) 1 April 18th 05 08:10 PM
Converting imported numbers to decimals (rather than /100) Frustrated Excel user Excel Worksheet Functions 2 April 5th 05 06:46 PM
How do I stop rounding numbers? Jfeeman Excel Discussion (Misc queries) 3 March 16th 05 02:49 PM
How do I make Excel stop rounding off my numbers that are 16 digi. Aida Excel Discussion (Misc queries) 1 December 6th 04 05:34 PM


All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"