Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
=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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |